Which database permission should you giant?

You maintain a SQL Server 2008 instance that contains a database named Finance.
In your absence, a user with a login named Rob will maintain the database snapshots.
You need to giant the appropriate permissions to the user to delete the database snapshots
for the Finance database.
Which database permission should you giant?

You maintain a SQL Server 2008 instance that contains a database named Finance.
In your absence, a user with a login named Rob will maintain the database snapshots.
You need to giant the appropriate permissions to the user to delete the database snapshots
for the Finance database.
Which database permission should you giant?

A.
DELETE

B.
CONTROL

C.
DROP DATABASE

D.
ALTER ANY DATASPACE



Leave a Reply 0

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