Re: Backup permission
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 06/08/04
- Next message: Hari: "Re: linking sqlserver with an other dbms"
- Previous message: Wayne Snyder: "Re: SQL DB Design Tool"
- In reply to: CC&JM: "Backup permission"
- Next in thread: CC&JM: "Re: Backup permission"
- Reply: CC&JM: "Re: Backup permission"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 8 Jun 2004 13:35:55 +0200
No need to start a new thread for this. I replied a few days ago that you need to check with the vendor of the
tool. It is likely that the tool vendor need you to be sysadmin, ignoring the fact that SQL Server allow you
to do backup is you are db_backupoerator (etc).
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "CC&JM" <anonymous@discussions.microsoft.com> wrote in message news:1991601c44d47$0a128860$a501280a@phx.gbl... Hello, I´ve some SQL Server databases that the backups are being made with integration of the Omniback Online Agent for SQL Server. At this moment i´ve one user configured for this integration and everything goes fine but the problem is that this user have 'Sysadmin' permissions, if i remove the user from the sysadmin in sql server i can do it if i give to this user the 'db owner' permission. Until now everything looks fine and normal. My question is that i want to restrict to the maximum the permissions of this user and if i give(put) this user in the db_backupoperator database role, that is suposed to work, when running the backup the report shows 0(zero)KB done. How can i resolve this issue? I really need to limit the access of this user for security and administration pruposes. Best Regards
- Next message: Hari: "Re: linking sqlserver with an other dbms"
- Previous message: Wayne Snyder: "Re: SQL DB Design Tool"
- In reply to: CC&JM: "Backup permission"
- Next in thread: CC&JM: "Re: Backup permission"
- Reply: CC&JM: "Re: Backup permission"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
