2.3.5 Assign Grants for Sandbox Schema

This section describes how to assign grants for Sandbox schema.

Note:

This section is not applicable for ASC use case.

Grant the following permissions to the newly created Oracle Database sandbox schema:

GRANT CONNECT TO <SANDBOX SCHEMA USER>;
GRANT CREATE SESSION TO <SANDBOX SCHEMA USER>;
GRANT CREATE PROCEDURE TO <SANDBOX SCHEMA USER>;
GRANT CREATE SEQUENCE TO <SANDBOX SCHEMA USER>;
GRANT CREATE TABLE TO <SANDBOX SCHEMA USER>;
GRANT CREATE TRIGGER TO <SANDBOX SCHEMA USER>;
GRANT CREATE VIEW TO <SANDBOX SCHEMA USER>;
GRANT CREATE MATERIALIZED VIEW TO <SANDBOX SCHEMA USER>;
GRANT CREATE SYNONYM TO <SANDBOX SCHEMA USER>;
GRANT CREATE RULE TO <SANDBOX SCHEMA USER>;
GRANT CREATE ANY TRIGGER TO <SANDBOX SCHEMA USER>;
GRANT DROP ANY TRIGGER TO <SANDBOX SCHEMA USER>;
GRANT CREATE ANY TYPE TO <SANDBOX SCHEMA USER>;