GRANT statement

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>;