Create administrative roles and profiles to provide additional users with administrative privileges. Add a descriptive prefix to each role and profile name. For example:
- R_role_name
- P_profile_name
- Log on as DBC.
-
Create the master administrative role R_Master_Admin. For example:
CREATE ROLE R_Master_Admin;
-
Provide privileges on DBC to the master administrative role. For example:
GRANT SELECT, EXECUTE ON DBC TO R_Master_Admin;
-
Provide privileges on sys_calendar to the master administrative role. For example:
GRANT SELECT, EXECUTE ON sys_calendar TO R_Master_Admin;
-
Create the master administrative profile P_Master_Admin. For example:
CREATE PROFILE P_Master_Admin AS SPOOL=350e9, TEMPORARY=0;