Oracle8 Database Administration - Manage Security ...iven a scenario in which an object privilege granted with GRANT OPTION is revoked, identify the pictorial representation of the result.
Display the system privileges granted at the database level by using Oracle SQL Worksheet.
Display the object privileges granted to users by using Oracle SQL Worksheet.
Unit 4: Managing Roles
Duration: 1 Hour(s)
Identify the characteristics of a more...
Oracle SQL Specifics Creating and Managing Database Objects ... database objects.
Use the GRANT statement with the WITH GRANT OPTION keyword to give another user access to your database objects and allow that user to pass these privileges.
Query the USER_TAB_PRIVS_RECD data dictionary table to confirm the privileges you have been granted.
Use the REVOKE statement to remove privileges granted to other users.
Use the CREATE SYNONYM statement to create a more...