You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database. What should you do？（）A.Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.B.Query the sys.server_permissions table on Server1.C.Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.D.Query the sys.database_permissions and sys.database_principals tables in the MedDB database.

单项选择题

You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database.
What should you do？（）

A.Use the SQL Server 2005 Management Studio to review the permissions of the default database objects.
B.Query the sys.server_permissions table on Server1.
C.Execute the sp_helplogins system stored procedure for each of the default users that the MedDATA application creates.
D.Query the sys.database_permissions and sys.database_principals tables in the MedDB database.

MCITP(70-444)