This discussion is archived
4 Replies Latest reply: Nov 19, 2012 5:07 AM by 845836 RSS

Need to grant DML privileges to all tables in few schemas

845836 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points