What should you do to do the following?

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?

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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *