Grant Schema Privileges
The following code shows how to perform various schema privilege grants to users and roles.
conn testuser1/testuser1@//localhost:1521/freepdb1 -- Sequences grant select any sequence on schema testuser1 to testuser2; grant select any sequence on schema testuser1 to t1_schema_role; -- Tables, views, materialized views grant select any table on schema testuser1 to testuser2; grant insert any table on schema testuser1 to testuser2; grant update any table on schema testuser1 to testuser2; grant delete any table on schema testuser1 to testuser2; grant select any table on schema testuser1 to t1_schema_role; grant insert any table on schema testuser1 to t1_schema_role; grant update any table on schema testuser1 to t1_schema_role; grant delete any table on schema testuser1 to t1_schema_role; -- Procedures, functions and packages grant execute any procedure on schema testuser1 to testuser2;
grant execute any procedure on schema testuser1 to t1_schema_role;
Revoke Schema Privileges
The following code shows how to revoke the schema privileges we granted earlier.
conn testuser1/testuser1@//localhost:1521/freepdb1 -- Sequences revoke select any sequence on schema testuser1 from testuser2; revoke select any sequence on schema testuser1 from t1_schema_role; -- Tables, views, materialized views revoke select any table on schema testuser1 from testuser2; revoke insert any table on schema testuser1 from testuser2; revoke update any table on schema testuser1 from testuser2; revoke delete any table on schema testuser1 from testuser2; revoke select any table on schema testuser1 from t1_schema_role; revoke insert any table on schema testuser1 from t1_schema_role; revoke update any table on schema testuser1 from t1_schema_role; revoke delete any table on schema testuser1 from t1_schema_role; -- Procedures, functions and packages revoke execute any procedure on schema testuser1 from testuser2; revoke execute any procedure on schema testuser1 from t1_schema_role;