4 Replies Latest reply on Nov 19, 2012 1:07 PM by 845836

    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