Backup-only ID

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stephanie - 19 May 2006 17:41 GMT

I have a stored procedure that I use to execute database backups. It deletes
old backup files and then creates the full backups of all the databases.

I want to create an ID that can only execute this procedure. I tried
creating a SQL ID with execute permission on this SP and then put the ID in
the db_backupoperator role in each database. But I keep running into
permission issues.

Any suggestions?

Reply to this Message

MeanOldDBA - 21 May 2006 03:29 GMT

What issues are you running into? Give specific examples and error messages.

Signature

MeanOldDBA
derrickleggett@hotmail.com
http://weblogs.sqlteam.com/derrickl

When life gives you a lemon, fire the DBA.

> I have a stored procedure that I use to execute database backups. It deletes
> old backup files and then creates the full backups of all the databases.
[quoted text clipped - 5 lines]
>
> Any suggestions?

Reply to this Message