Oracle - 授予所有用户权限
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1643705/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle - grant privileges to all users
提问by Richard Knop
I need to grant privileges to all users, I can do:
我需要向所有用户授予权限，我可以这样做：
GRANT select on table TO user1;
GRANT select on table TO user2;
...
But there are many users. How can I grant this privilege to all users at once?
但是有很多用户。如何一次向所有用户授予此权限？
I tried:
我试过：
GRANT select on table TO ALL;
But that doesn't work.
但这不起作用。
回答by Jim Hudson
grant select on table to public;
But be careful when you do that -- make sure it's what you really want to do.
但是当你这样做时要小心——确保这是你真正想要做的。
回答by Dani
You should use roles. Grant permission to roles. grant roles to users.
你应该使用角色。授予角色权限。授予用户角色。
