4. You are an administrator of a SQL Server 2000 computer. Joe, a Sales departament employee, has a SQL Server login named Joe.He uses this login to access the SalesData database.

Joe has been temporarly moved to the Purchase departament. He wants to view and edit information stored in the PurchaseData database. Both these databases are located on the same SQL Server. You have to configure the appropiate permissions for Joe on the PurchaseData database. Which T-SQL statement will you execute to accomplish the task.

A. GRANT SELECT ON PurchaseData to 'Joe'

    GRANT INSERT ON PurchaseData TO 'Joe'

    GRANT UPDATE ON PurchaseData TO 'Joe'

B. EXEC sp_grantdbaccess 'Joe', 'JoeU'

    EXEC sp_addrolemember 'db_datareader', 'JoeU'

    EXEC sp_addrolemember 'db_datawriter', 'JoeU'

C. EXEC sp_addrolemember 'db_datareader', 'JoeU'

    EXEC sp_addrolemember 'db_datawriter', 'JoeU'

D. GRANT ALL ON PurchaseData TO 'Joe'

P.S. asta mi-o aduc aminte pt ca am gasit-o intr-un test dupa ;)