Now you are going to create a new role for your users


#Creating a Role
Now you are going to create a new Role for your users to take advantage of.

Create a role called DEV and assign privileges to the Role that will allow a user to:

1. Create a session
2. Create a table
3. Create a view
4. Enable a user select from Scott's EMP table. 

Hint: Remember that a member assigned to this roll must be able to create the table in any tablespace. Also, you cannot assign System privileges and Object privileges in the same GRANT statement.

You should get responses that look similar to this:

Role created.

Grant succeeded.

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Now you are going to create a new role for your users
Reference No:- TGS0145646

Expected delivery within 24 Hours