You have been given the task of documenting the process and commands required for creating a new user and assigning privileges to that user for one or more of the tables in a DBA’s practice database layout below. This process will be documented schematically in the table below that will: - identify all SQL commands (using proper role names, table names, user names, etc. and proper syntax), - identify which user (DBA or NEW USER) should execute each command, and - detail the expected outcome based on your knowledge of Oracle data administration, roles, and granting and revoking privileges to roles. Initially, the new user will not be able to do anything, including any selects, inserts, updates, or deletes on any of the DBA’s tables. The DBA will create a role and assign the new user to that role. Then, the DBA will grant and revoke various select, insert, update or delete privileges to the role. It is your responsibility to determine the outcome. You will not be able to execute any of these commands in a live environment. The DBA would like for you to complete this documentation to help a new intern learn the process. The intern will arrive early n
You have been given the task of documenting the process and commands required for creating a new user and assigning privileges to that user for one or more of the tables in a DBA’s practice
This process will be documented schematically in the table below that will:
-
- identify all SQL commands (using proper role names, table names, user names, etc. and proper syntax),
-
- identify which user (DBA or NEW USER) should execute each command, and
-
- detail the expected outcome based on your knowledge of Oracle data administration, roles, and granting and revoking
privileges to roles.
Initially, the new user will not be able to do anything, including any selects, inserts, updates, or deletes on any of the DBA’s tables. The DBA will create a role and assign the new user to that role. Then, the DBA will grant and revoke various select, insert, update or delete privileges to the role. It is your responsibility to determine the outcome.
You will not be able to execute any of these commands in a live environment. The DBA would like for you to complete this documentation to help a new intern learn the process. The intern will arrive early next week.
The database relational schema and sample data are shown below. You should study the tables and data to become familiar with the layout prior to completing this work.
1. The DBA would like to execute a select on this view and make it available to all users in the role and commit his work.
2. The new user hears about this new view and wishes to try it out by doing a select of all records on the view.
3. The DBA would like to create another role and grant INSERT and DELETE access to all four (4) of his tables from this database to the following users: student1, student2, student3, student4 and student5.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
