September 17, 2009 at 6:24 am
Hi folks.
I need some help with the "rights" of the user.
I've a login called "MYLOGIN" and a user into db also called "MYLOGIN".
So, I wanna give this user permission to READ AND WRITE data, execute stored procedures and make backups... just these, nothing more.
When I'm creating a login I'm checking db_datareader and db_datawriter for database role but with this roles I'm unable to execute stored procedures and backups with this login.
How I do give permissions to execute sp and make backups to these login?
I'm using SQL Server 2008 Express.
September 17, 2009 at 6:49 am
willian-1136841 (9/17/2009)
Hi folks.I need some help with the "rights" of the user.
I've a login called "MYLOGIN" and a user into db also called "MYLOGIN".
So, I wanna give this user permission to READ AND WRITE data, execute stored procedures and make backups... just these, nothing more.
When I'm creating a login I'm checking db_datareader and db_datawriter for database role but with this roles I'm unable to execute stored procedures and backups with this login.
How I do give permissions to execute sp and make backups to these login?
I'm using SQL Server 2008 Express.
grant execute to mylogin
will give you exec stored procedures
sp_addrolemember 'db_backupoperator','mylogin'
will allow that user to backup that database only
remember to use the relevant database first before running the commands
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 17, 2009 at 11:59 am
Thanks!
It worked fine!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply