SQL

Q10.Grant to the SCOTT access to your CUSTOMER table. Lab Exercises Q1. Create user name "DBLAB10B", set password "db321". Q11.connect to the SCOTT user then query all the rows from your CUSTOMER table. Q2. What are the privileges that should be granted to the user to log in the oracle server? Q12.Connect to your account then grant the CUSTOMER privileges to update (phone, and Total) columns in the STUDENT table. Q3. What are the privileges that should be granted to the user to create tables? Q4. If you create a table, who can pass a long privileges to other users on your table. Q13.Connect to the SCOTT user, then change the phone and total for the "leen" as follows: name leen Order_id 54321 phong 0739999999 total 25 Q5. You are the DBA, you are creating many users who require the same system Privileges, what would you use to make your job easy? Give example. Q14.How you can make the SCOTT passes the privileges on the student table to other Users Q6.what the command do you use to change your password to "cba". Q7. Show how you can lock the SCOTT account. Q15. Revoke the SELECT privilege from SCOTT. 08. Show how you can unlock the SCOTT account. 09. Connect to the "DBLAB10B" user, then create the CUSTOMER table as follows: name saad leen Order Id 12345 54321 phone 0722321456 0732587777 total 30 70