Tuesday, February 18, 2020

How to create a ops$oracle account ?


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