You work as a database administrator at Domain.com. Domain.com is using a SQL Server
2008 instance that contains a database named CK_Prod. Domain.com has a SQL Server login
named CK_Tst that maps to a Domain.com learner administrator named CK_ProdApp in CK_Prod.
You have received instruction from management that the Domain.com user can to do the following:
* That the entire stored procedures which at present exist in CK_Prod can be run.
* That the entire stored procedures will be developed in CK_Prod can be run.
What should you do?
A.
You should consider allowing the proper database-level rights to default database.
B.
You should consider allowing the proper database-level rights to CK_Tst.
C.
You should consider allowing the proper database-level rights to CK_ProdApp.
D.
You should consider increasing a new role in the default domain group.