Oracle 10g Login as system write a SQL statement to create a user named chap7 an
ID: 639040 • Letter: O
Question
Oracle 10g
Login as system
write a SQL statement to create a user named chap7 and give the user a password = chap7, assign the user a default tablespace of users, a temporary tablespace of temp and the default profile.
Login as system
write a SQL statement that will allow chap7 to create a table and create a view with administrative rights.
Log off as system and log on as chap7. In the SQL window write a query to display all of the columns in the emp table.
Log in as system, create a role called chap7_role
Verify that chap7_role is listed as a session role.
Give chap7_role select privileges on the dept table.
Give the chap7_role to user chap7 with admin options.
Log on as user chap7 and provide the SQL and display that shows the session role(s) assigned to user chap7.
As user chap7 create a SQL query and output display to show all of the columns found in the system dept table.
Log off as chap7 and log on as system. Remove the chap7_role.
Write a SQL statement to display a list showing that chap7_role is no longer a session role.
Explanation / Answer
-------------------------------------------------------------------------------
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.