Write the appropriate SQL statement for the following queries. The result of the queries will be checked from your computer.

1. What privilege should a user be given to log on to the Oracle server? Is this a system privilege or an object privilege?

1. What privilege should a user be given to create tables?

1. If you create table, who can pass along privileges to other users on your table?

1. You are the DBA. You are creating many users who require the same system privileges. What should you use to make your job easier?

1. What command do you use to change your password?

1. User1 is the owner of the EMP table and grants the DELETE privilege to User2 by using the WITH GRANT OPTION clause. User2 then grants the DELETE privilege on EMP to User3. User1 now finds that User3 has the privilege and revokes it from User2. Which user can now delete from the EMP table?

1. You want to grant SCOTT the privilege to update data in the DEPARTMENTS table. You also want to enable SCOTT to grant this privilege to other users. What command do you use?

1. Grant another user query privilege on your table. Then, verify whether that user can use the privilege. Note: For this exercise, team up with another group. For example, if you are user ora21, team up with another user ora22.
2. 
   
3. 1. Grant another user privilege to view records in your REGIONS table. Include an option for this user to further grant this privilege to other users.
    
   2. Have the user query your REGIONS table.
    
   3. Have the user pass on the query privilege to a third user (for example, ora23).
    
   4. Take back the privilege from the user who performs step b.