Friday, March 23, 2012

Grant all privileges to a user

Is it possible to grant all privilege for all tables of a specified database through script? Because i have to send the script to user side and i can't do it manually in Enterprise Manager.

regards,

Add the user to the db_owner database role of that database:

use databasename

go

sp_addrolemember db_owner,username

No comments:

Post a Comment