Create a User - Exercise

Contact Us or call 1-877-932-8228
Create a User - Exercise

Create a User

Duration: 5 to 10 minutes.
  1. Log in as a DBA user.
  2. Create a new user.
  3. Set the user's default table space to USERS.
  4. Grant the user RESOURCE and CREATE SESSION privileges.
  5. Grant the user the ability to select from the HR departments table.
  6. Grant the user the ability to insert into the HR departments table.
  7. Grant the user the ability to delete from the HR departments table.
  8. Connect as the new user.
  9. Execute the following: SELECT * FROM HR.DEPARTMENTS;

Solution:

Users-and-Schemas/Solutions/user_solution.sql
                
Next