Question

Need help with this assignment. Need code and screenshots.

Using SQL Developer and SQLPlus

Here is the information.

1. Create user user1

a. The default tablespace is USERS.

b. The temporary tablespace is TEMP.

c. The account is initially locked.

d. The user account will be assigned to DEFAULT profile.

e. The USERS tablespace has a 10 MB quota. provide your statement here

2. Use SQLPlus to connect as user1. Explain what happened and way to fix it.

3. Give user1 permission to see information in OE.CUSTOMERS table

4. Test the permission you granted

5. As user1 update the last name of the customer with customer ID 188. Explain results.

6. When you connected as user1 find all objects which names starts with DBA_. Connect as system, find all objects which names starts with DBA_. Explain the difference in information. HINT: Use ALL_OBJECTS;

7. Make user1 account password expire.

8. Use SQLPlus. Login as user1, and describe how you changed the password.

9. Create role customer_entry

10. Grant role customer_entry permission to update OE.CUSTOMERS table

11. Add user1 to the role customer_entry

12. Check permissions you granted by using data dictionary view

13. Check permissions you granted by using user1 account to update OE.CUSTOMERS table.

14. What procedures would you follow if you were told that an employee was terminated?

Please and Thank you.

Answer 1

Answer 1

create user user1 identified by password;

Answer a

Create tablespace USERS datafile 'userdata.dat' size 50M;

Answer b

Create temperory tablespace TEMP datafile 'tempdata.dat' size 50M;

Answer c

revoke all on user1;

Answer d

create profile myprofile;
alter user user1 profile myprofile;