Syntax for GRANT statement
GRANT SELECT ON all_objects to <Schema_name>;
GRANT EXECUTE ANY PROCEDURE to <Schema_name>;
GRANT CONNECT TO <Schema_name>;
GRANT RESOURCE TO <Schema_name>;
ALTER USER <Schema_name> DEFAULT ROLE ALL;
GRANT SELECT ANY TABLE TO <Schema_name>;
GRANT CREATE SESSION TO <Schema_name>;
GRANT CREATE TRIGGER TO <Schema_name>;
GRANT CREATE ANY VIEW TO <Schema_name>;
ALTER USER <Schema_name> QUOTA UNLIMITED ON <Schema_name>;
grant create any procedure to <Schema_name>;
grant create table to <Schema_name>;
grant create view, create procedure, create sequence to <Schema_name>;
GRANT DROP ANY TABLE to <Schema_name>;
GRANT DELETE ANY TABLE to <Schema_name>;
GRANT INSERT ANY TABLE to <Schema_name>;
GRANT UPDATE ANY TABLE to <Schema_name>;
GRANT EXECUTE ANY PROCEDURE to <Schema_name>;
GRANT CREATE ANY SEQUENCE to <Schema_name>;
GRANT CREATE SYNONYM to <Schema_name>;
grant create any index to <Schema_name>;
GRANT READ ANY TABLE TO <Schema_name>;
GRANT SELECT ANY DICTIONARY TO <Schema_name>;
GRANT CREATE TRIGGER TO <Schema_name>;
GRANT SELECT ANY TABLE TO <Schema_name>;
GRANT CREATE ANY VIEW TO <Schema_name>;
For example, if we want our books_admin user to have the ability to perform
SELECT, UPDATE, INSERT, and DELETE capabilities on the books table,
we might execute the following GRANT statement:
GRANT SELECT,INSERT,UPDATE ON <Schema_name>.Table_name TO <Schema_name>;
