As SQL Server 2000 DBA, you should grant select permission to the Products table for all members of the Management department. There are Admin, Management, Tech and Sales database roles. Ravi has recently been transferred to the Management department from the Tech department and added to the Management role. The Tech role has been denied access to the Products table. All employees from the Management department have select permission to the Products table, but Ravi does not have. You should grant select permission to the Products table for Ravi. What should you do?
A. GRANT SELECT ON Products TO Ravi
B. sp_addrolemember db_owner , Ravi
C. sp_droprolemember Tech , Ravi
D. sp_addrolemember Admin , Ravi
Answer:C
As SQL Server 2000 DBA, you should grant select permission to the Products table for all members of the Management department. There are Admin, Management, Tech and Sales database roles. Ravi has recently been transferred to the Management department from the Tech department and added to the Management role. The Tech role has been denied access to the Products table. All employees from the Management department have select permission to the Products table, but Ravi does not have. You should grant select permission to the Products table for Ravi. What should you do?
A. GRANT SELECT ON Products TO Ravi B. sp_addrolemember db_owner , Ravi C. sp_droprolemember Tech , Ravi D. sp_addrolemember Admin , Ravi