CODEWITHSUNDEEP
oracle-database
Richard Knop
Richard Knop

Reputation: 83677

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 can I grant this privilege to all users at once?

I tried:

GRANT select on table TO ALL;

But that doesn't work.

Upvotes: 23

Views: 56289

Answers (2)

Dani
Dani

Reputation: 15069

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

Upvotes: 7

Jim Hudson
Jim Hudson

Reputation: 8069

grant select on table to public;

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

Upvotes: 33

Related Questions