网友您好, 请在下方输入框内输入要搜索的题目:
YouaretheadministratorofaMicrosoftWindowsServer2003computernamedServer1.SQLServer2005isinstalledonServer1tohostadatabasenamedMedDB.TheMedDBdatabaseservesasthebackenddatabaseforanewclient/serverapplicationnamedMedDATA.InstallationoftheMedDATAapplicationcreatesthedatabaseschema,applicationroles,andadministrativeaccounts.Italsosetsallofthedefaultpermissions.YouneedtoestablishapermissionsbaselineforallobjectsintheMedDBdatabase.Whatshouldyoudo?()
A.UsetheSQLServer2005ManagementStudiotoreviewthepermissionsofthedefaultdatabaseobjects.
B.Querythesys.server_permissionstableonServer1.
C.Executethesp_helploginssystemstoredprocedureforeachofthedefaultusersthattheMedDATAapplicationcreates.
D.Querythesys.database_permissionsandsys.database_principalstablesintheMedDBdatabase.
参考答案