Monday, August 18, 2014

create a DBA like PRIVILEGED user in ORACLE

create a DBA like PRIVILEGED user in ORACLE


create user dba_monitor identified by dba_monitor;
grant connect, select_catalog_role to dba_monitor;


This SELECT_CATALOG_ROLE will not give all DBA privileges so just make sure before creating any user this role.




No comments:

Post a Comment