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.
正确答案:D
答案解析:有
微信扫一扫手机做题