Assign the administrative role and profile to the SYSDBA user. You cannot specify WITH GRANT OPTION for roles. You specify WITH ADMIN OPTION to enable SYSDBA to change permissions in the role and determine to whom to grant or revoke the role. Omit this option for non-administrative users.
- Log on as DBC.
- Grant the master administrative role to SYSDBA. For example:
GRANT R_Master_Admin TO SYSDBA WITH ADMIN OPTION;
- Modify the SYSDBA administrative user. For example:
MODIFY USER SYSDBA AS DEFAULT ROLE=R_Master_Admin, PROFILE=P_Master_Admin;
- Log off.