开发者

Oracle - grant privileges to all users

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 ca开发者_如何学运维n I grant this privilege to all users at once?

I tried:

GRANT select on table TO ALL;

But that doesn't work.


grant select on table to public;

But be careful when you do that -- make sure it's what you really want to do.


You should use roles. Grant permission to roles. grant roles to users.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜