Use PL/SQL 1.Create user user1 a.The default tablespace is USERS. b.The temporar
ID: 3802427 • Letter: U
Question
Use PL/SQL
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?
Explanation / Answer
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;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.