Saturday, June 11, 2011

How to assign normal privilages for any database user

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

No comments:

Post a Comment