SQLTeam.com | Weblogs | Forums

Hello need some help to do this problem

sql2008

#1

Write the SQL statement(s) needed to grant BOB the access to some columns of the Authors table.

Write the SQL statement(s) needed to grant ORDERUSER access to some rows of the Customers table.

Suppose SAM now wants GEORGE to act as his security administrator. Write the SQL statement(s) needed to give GEORGE the necessary privileges.

Suppose that GEORGE executed SQL statements to grant BOB access to the database. What happens to BOB if SAM executes the SQL statement below? Explain your answer.

REVOKE SELECT
ON SALESREPS
FROM GEORGE;

Suppose that your DBMS contains a user identified with PHIL as his/her user ID. Write a SQL statement that removes PHIL's read privileges to the ORDERS table.


#2
  1. what is your question?
  2. what have you tried?
  3. where are you having trouble?
  4. homework?