开发者

Oracle - grant privileges to all users

开发者 https://www.devze.com 2022-12-09 15:02 出处:网络
I need to grant privileges to all users, I can do: GRANT select on table TO user1; GRANT select on table TO user2;

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

精彩评论

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