GR wrote:There is no single command to grant privileges at that level. There are either ANY privileges or privileges on an object.
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>;
Veeresh.S wrote:or 'GRANT ALL...' if that is what is really wanted.
select 'GRANT SELECT ON '||OWNER||'.'||TABLE_NAME||' to ROLE_NAME;' as grant_select FROM dba_tables WHERE owner in ('SCOTT','X_USER','Y_USER');