4 Replies Latest reply: Nov 19, 2012 7:07 AM by 845836 RSS

    Need to grant DML privileges to all tables in few schemas

    845836
      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