Answer to Question #63225 in Databases | SQL | Oracle | MS Access for jonney

Question

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

C)create user sami assign him the password dana.

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

f)Create a role called danger, which enables the user called sami to create a table, create a view