oracle grant select on schema

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

Search
showing results for - "oracle grant select on schema"
Jakob
21 Oct 2020
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
create schema oracle sql 19ccross schema query oracle 2 usersoracle all tables in schemaoracle get table schemaoracle drop useroracle grant roleoracle role useroracle create role privilegeoracle create schemaoracle table privilegesoracle query to find schema you are working onoracle user tableshow to check schema privileges in oracleoracle drop all schema tablesoracle drop schema proceduresselect dba users oracleoracle user privilegesoracle privileges usersoracle grant create joboracle list privilegesoracle create as selectoracle show grants on tableoracle query to see what scema i am working inoracle drop all user viewsgrant access on table in oracleoracle revoke grant
queries leading to this page
grant to all tables oracleoracle grant select to another schemagrant access on schema oraclegrant dba on another schema in oraclegrant schema oracleoracle grant create table on schemagrant select view in oracleoracle grant select any tableoracle gives grant to another schemaoracle table grant listoracle grant select to all tablesgrant for select only to other schema oraclegrant to different schema in oracleoracle grant all tablesoracle grant access to schemahow to grant select on a schema in oracleselect grant view oracleoracle grant to a schemaoracle grant on all tables in schemaoracle grant select on table to another schema grantable tableoracle grant schema to roleoracle grant select on schemaoracle grant selectgrant select on all tables in schema oracleoracle grant select on schema