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

Question

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 .