SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to grant DML privileges to all tables in few schemas

845836Nov 19 2012 — edited Nov 19 2012

Hi,
I need to grant DML privileges to all tables in few schemas to a role. How can I achieve that?

I thought it's below syntax but it doesn't work. Please advice.

grant ALL ON ALL TABLES IN SCHEMA <Schema_name>  TO <role_name>;

Thanks,
Gangadhar

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 17 2012

Added on Nov 19 2012

4 comments

7,677 views