Create user roles for general, update, and batch operations.
- Log on as SYSDBA.
-
Create the general user role. For example:
CREATE ROLE R_General_User;
-
Grant the necessary privileges to the general user role. For example:
GRANT SELECT, EXECUTE ON General_Views TO R_General_User;
-
Create the update user role. For example:
CREATE ROLE R_Update_User;
-
Grant the necessary privileges on the General_Views and Update_Views databases to the update user role. For example:
GRANT SELECT, EXECUTE ON General_Views TO R_Update_User;
GRANT SELECT, EXECUTE, INSERT, DELETE, UPDATE ON Update_Views TO R_Update_User;
-
Create the batch user role. For example:
CREATE ROLE R_Batch_User;
-
Grant the necessary privileges to the batch user role. For example:
GRANT SELECT, INSERT, DELETE, UPDATE, TABLE, CHECKPOINT, DUMP, RESTORE ON Tables_Database TO R_Batch_User;