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 (user40 user50) password the same as user name
Grants privileges to allow the users to create tables, sequences, and views (i.e. 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 user40 schema
Grants privilege for user50 to query the table in the user40 schema (verify that only user50 can perform a query; e.g., show that an error occurs when other users try to access)
Save as Project12a.sql

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!