You can revoke sysdba privileges from HR schema.
REVOKE sysdba from HR.
Normal HR schema will have privileges as below
GRANT CREATE SESSION TO hr;
GRANT ALTER SESSION TO hr;
GRANT CREATE DATABASE LINK TO hr;
GRANT CREATE SEQUENCE TO hr;
GRANT CREATE SYNONYM TO hr;
GRANT CREATE VIEW TO hr;
GRANT RESOURCE TO hr;
GRANT execute ON sys.dbms_stats TO hr;
You can find demo scripts at
$ORACLE_HOME/demo/schema folder
REVOKE sysdba from HR.
Normal HR schema will have privileges as below
GRANT CREATE SESSION TO hr;
GRANT ALTER SESSION TO hr;
GRANT CREATE DATABASE LINK TO hr;
GRANT CREATE SEQUENCE TO hr;
GRANT CREATE SYNONYM TO hr;
GRANT CREATE VIEW TO hr;
GRANT RESOURCE TO hr;
GRANT execute ON sys.dbms_stats TO hr;
You can find demo scripts at
$ORACLE_HOME/demo/schema folder
No comments:
Post a Comment