Can someone please show me how to complete this assignment with step by step ins
ID: 3806458 • Letter: C
Question
Can someone please show me how to complete this assignment with step by step instructions on how to complete these questions please with code and screenshots.
In SQL Developer and SQL Plus
Here is the information.
1. Create user user1
The default tablespace is USERS.
The temporary tablespace is TEMP.
The account is initially locked.
The user account will be assigned to DEFAULT profile.
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
Explanation / Answer
1. ) Creating User
2.) sql plus to connect the user
Open a UNIX or a Windows terminal and enter the SQL*Plus command:
When prompted, enter your Oracle Database username and password. If you do not know your Oracle Database username and password, ask your Database Administrator.
Alternatively, enter the SQL*Plus command in the form:
To hide your password, enter the SQL*Plus command in the form:
You will be prompted to enter your password.
SQL*Plus starts and connects to the default database.
Now you can start entering and executing SQL, PL/SQL and SQL*Plus statements and commands at the SQL> prompt
3.) Granting privileges to user1
GRANT SELECT, INSERT, UPDATE, DELETE ON customer TO user1;
4.) Testing the privileges of the user