You will create a SQL script to perform for the following tasks:

1. Connect to appropriate user (5 points)
   
   
2. Create a user "tecuser" with a password "mynewpassword". (25 points)
   
   
3. Create a role named "tecrole". (25 points)
   
   
4. Grant CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE ANY INDEX to "tecrole". (25 points)
   
   
5. Grant role "tecrole" to "tecuser". (20 points)
   
   
6. Please make sure the exact spelling is required on everything we do or create.

Tip:

You will have to login as a user with appropriate privileges to perform the above tasks. Otherwise, you will run into errors.

Submit your project through WebCT. If you need instructions on how to submit, click here.

Please submit your SQL script for performing the tasks of this project. (SQL script is in .sql format, which can be run in Oracle as SQL>@filepath\file.sql, for example, SQL>@C:\temp\myscript.sql.)

Please use the same file convention for this course.

 

At the end of this week. Please see the course schedule for exact due date.