Question: Creates eleven users ( user 4 0 user 5 0 ) password the same as user name Grants privileges to allow the users to create
Creates eleven users user user password the same as user name
Grants privileges to allow the users to create tables, sequences, and views ie lookup the syntax for using these apply in addition to "CONNECT" shown below; refer to System Privileges link; can use separate GRANT statements or possibly a single statement
Creates a table Refer to the SQL Reference manual; CREATE TABLE statement in the user schema
Grants privilege for user to query the table in the user schema verify that only user can perform a query; eg show that an error occurs when other users try to access
Save as Projectasql
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
