68 329
Assignments Done
Successfully Done
In November 2018

Answer to Question #62311 in Databases | SQL | Oracle | MS Access for johnny

Question #62311
Q2:Write a DBA statements to perform the following operations:(after each statement show the result of your work on database.)
A) Create user john. Assign him a password of adam and require that john change his password the next time he logs on.
B)create a table in the schema of john.

C)create user michael assign him the password dana.

D) connect as john and give michael the ability to select from john's CUSTOMERS table.Also, enable michael to give the select capability to other users.
E) remove from michael the ability to select from john'customer table.

f)Create a role called danger, which enables the user called michael to create a table, create a view .
Expert's answer

Not answered

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!


No comments. Be first!

Leave a comment

Ask Your question

Privacy policy Terms and Conditions