CREATE USER "OPS$ORACLE" IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE
"USERS"
TEMPORARY TABLESPACE
"TEMP"
PROFILE "APPUSER";
GRANT "CONNECT" TO OPS$ORACLE ;
GRANT "EXP_FULL_DATABASE" TO OPS$ORACLE ;
GRANT "DBA" TO OPS$ORACLE ;
GRANT "IMP_FULL_DATABASE" TO OPS$ORACLE ;
ALTER USER OPS$ORACLE DEFAULT ROLE
"CONNECT","EXP_FULL_DATABASE","DBA","IMP_FULL_DATABASE";
-- SYSTEM PRIVILEGES
GRANT ALTER SESSION TO OPS$ORACLE WITH ADMIN OPTION;
GRANT CREATE VIEW TO OPS$ORACLE ;
GRANT CREATE SESSION TO OPS$ORACLE ;
GRANT CREATE TABLE TO OPS$ORACLE ;
GRANT SELECT ANY DICTIONARY TO OPS$ORACLE ;
GRANT CREATE SYNONYM TO OPS$ORACLE ;
GRANT CREATE SEQUENCE TO OPS$ORACLE ;
GRANT CREATE DATABASE LINK TO OPS$ORACLE ;
GRANT ALTER SYSTEM TO OPS$ORACLE WITH ADMIN OPTION;
GRANT UNLIMITED TABLESPACE TO OPS$ORACLE ;
GRANT CREATE CLUSTER TO OPS$ORACLE ;
No comments:
Post a Comment