This needs to be done on SQL Plus I need both the SQL statements and the output
Question:
This needs to be done on SQL Plus I need both the SQL statements and the output of the statements
1. Use SQL to a polyinstantiated table including a primary key and a unique constraint
2.Use SQL to insert multiple records for each security classification with the same ID. You must have 4 classifications.
3.Use SQL to create 4 schemas, one for each security classification 4.Use SQL to a view in each schema that restricts the records to those belonging to a particular security classification and restricts the columns to only those columns that have relevant data.
5.Select from each of the views. Take a screen shot of the query results for each user(total of 4 for this step).
6.Use SQL to create 4 logins, one for eachsecurity classification
7.Use SQL to create 4 database users, one for each login with a default schema that matches the security classification for the login.
8.Use SQL to create 4 roles at the database level, one for each security classification.
9.Use SQL to assign each user to its specific role.
10.Use SQL to grant select on the appropriate view to the roles.
11.Execute tests as each of the four users, trying to select from their respective views. Take a screen shot of the query results for each user(total of 4 for this step).
12.Use SQL to revoke select on the view from the role
13.Use SQL to remove the users from the role
14.Use SQL to drop the users
15.Use SQL to drop the logins
16.Use SQL to drop the roles1
7.Use SQL to drop the views
18.Use SQL to drop the schemas
19.Use SQL to drop the table
Accounting Information Systems
ISBN: 9780132871938
11th Edition
Authors: George H. Bodnar, William S. Hopwood