oracle grant on all tables in schema

Solutions on MaxInterview for oracle grant on all tables in schema by the best coders in the world

Search
showing results for - "oracle grant on all tables in schema"
Paula
26 Sep 2019
1BEGIN
2   FOR R IN (SELECT owner, table_name FROM all_tables 
3             WHERE owner='OTHER_SCHEMA') LOOP
4      EXECUTE IMMEDIATE 'GRANT SELECT, INSERT, UPDATE, DELETE ON ' ||
5                         R.owner || '.' || R.table_name || ' TO MY_SCHEMA';
6   END LOOP;
7END;
similar questions
oracle table privilegesoracle list columns schemaoracle grant create joblocked tables in oracleoracle all tables in schemaoracle tablespace tables listhow to see all table partition in oracletablespace oracleoracle list tablesoracle grant rolesize of all tables in a schema oracleoracle get table schemashow all tables in oracleoracle user tablesoracle revoke grantoracle privileges usersoracle drop all schema tablesoracle all tablesoracle size of tables in schemaoracle show grants on tableshow tables in oraclehow to check schema privileges in oracleoracle list tablespacesoracle list privilegesgrant access on table in oracle
queries leading to this page
oracle grant schema to roleoracle grant on all tables in schemaoracle gives grant to another schemaoracle grant create table on schemaoracle grant select on schemaoracle grant select to all tablesoracle grant all tablesoracle grant select to another schemaoracle grant selectgrant to different schema in oracleoracle grant select on table to another schema grantable tablegrant schema oraclehow to grant select on a schema in oraclegrant dba on another schema in oracleoracle grant to a schemaselect grant view oraclegrant to all tables oracleoracle grant access to schemaoracle table grant listgrant access on schema oraclegrant for select only to other schema oraclegrant select on all tables in schema oracleoracle grant on all tables in schema