Re: restore permissions to a login
From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 05/17/04
- Next message: James: "Re: Multiple or single datafiles?"
- Previous message: SQL Starter: "Backup and Restore from comman line"
- In reply to: Biva: "restore permissions to a login"
- Next in thread: Hari Prasad: "Re: restore permissions to a login"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 17 May 2004 17:25:52 +0100
Technically the permissions you have assigned should be enough to backup and
restore the database. Whether the 3rd party solution has the need for the sa
account hard coded in the application, I do not know, but in that case I
would not use that solution. If they can't even get something as simple as
the permissions right (and the least the can do is just allow any member of
sysadmin as the login. I mean, what about SQL Server installations that use
Windows Authentication only?), what can you expect from the rest of the
application?
-- Jacco Schalkwijk SQL Server MVP "Biva" <biva.yauchler@redprairie.com> wrote in message news:40a8e53b$0$974$39cecf19@news.twtelecom.net... > Hello All, > > I have run into a situation that a 3rd party backup and restore solution is > requiring sa account to backup and restore databases in my SQL 2K/SP3a > server. > I have created a login that is a member of db_backupoperator and db_onwer > database roles and database_creators server role. Isn't that enough? does > it absolutely need sa privilege? Please enlighten me if you have run into > the same scenario. > > Thanks, > sqlgirl > >
- Next message: James: "Re: Multiple or single datafiles?"
- Previous message: SQL Starter: "Backup and Restore from comman line"
- In reply to: Biva: "restore permissions to a login"
- Next in thread: Hari Prasad: "Re: restore permissions to a login"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
Loading
