What action should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. ABC.com has a SQL Server login named
ABC_Tst _Login that maps to a ABC.com learner administrator named ABC_ProdAppUser in
ABC_Prod. You have received instruction from management that you need to restrict
ABC_ProdAppUser so that it only can run stored procedures (current and future). It should not be
allowed to execute other tasks in the database.
What action should you take?

You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008
instance that contains a database named ABC_Prod. ABC.com has a SQL Server login named
ABC_Tst _Login that maps to a ABC.com learner administrator named ABC_ProdAppUser in
ABC_Prod. You have received instruction from management that you need to restrict
ABC_ProdAppUser so that it only can run stored procedures (current and future). It should not be
allowed to execute other tasks in the database.
What action should you take?

A.
You should consider allowing the proper ojbect-level rights to default database.

B.
You should consider allowing the proper ojbect -level rights to ABC_Tst_login

C.
You should consider allowing the proper ojbect -level rights to ABC_ProdApp_User.

D.
You should consider allowing the proper ojbect -level rights to Anonymous User.

E.
You should consider allowing the proper database-level rights to default database.

F.
You should consider allowing the proper database-level rights to ABC_Tst_login

G.
You should consider allowing the proper database-level rights to ABC_ProdApp_User.

H.
You should consider allowing the proper database-level rights to Anonymous User.

I.
You should consider allowing the proper server-level rights to default database.

J.
You should consider allowing the proper server -level rights to ABC_Tst_login
K.
You should consider allowing the proper server -level rights to ABC_ProdApp_User.
L.
You should consider allowing the proper server -level rights to Anonymous User.
M.
You should consider increasing a new role in the default domain group.

Explanation:

Right click database
select properties
select permissions
add the user
scroll down to “EXECUTE” then check “GRANT”
This grant execute permissions on all stored procedures.



Leave a Reply 0

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