create ops user

spool create_ops_user.log
/
CREATE USER OPS$ABC IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK
/
GRANT "CONNECT" TO OPS$ABC
/
GRANT DEVELOPMENT TO OPS$ABC
/
GRANT "RESOURCE" TO OPS$ABC
/
ALTER USER OPS$ABC DEFAULT ROLE "CONNECT", DEVELOPMENT, "RESOURCE"
/
GRANT CREATE SESSION TO OPS$ABC
/
GRANT UNLIMITED TABLESPACE TO OPS$ABC
/
spool off
/