Re: permission required for a backup operator
From: Carlos Caballero (CarlosCaballero_at_discussions.microsoft.com)
Date: 08/31/05
- Previous message: Keith G Hicks: "windows authentication question"
- In reply to: Dan Guzman: "Re: permission required for a backup operator"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 31 Aug 2005 08:31:19 -0700
Dan,
I have fixed the user as an db_backupoperator database role and I still have
the same problem, the thing is that when the operator try to backup the
database he can't use the tape device. I have tried creating a backup device
pointing to the tape but the operator still can't see it. Do you have any
other idea?
"Dan Guzman" wrote:
> Have you tried granting BACKUP DATABASE statement permissions? Another
> method is to add the user to the db_backupoperator fixed database role.
>
> --
> Hope this helps.
>
> Dan Guzman
> SQL Server MVP
>
> "Carlos Caballero" <CarlosCaballero@discussions.microsoft.com> wrote in
> message news:24025B3A-A2AF-4AA3-84AE-0893E76D4A26@microsoft.com...
> >I have installed SQL Server 2000 in a Wondows 2000 Server, and I need to
> >set
> > permissions for a user to only backup data bases to tape media, I have
> > tried
> > everything without any results, does any one have any clue about this.
>
>
>
- Previous message: Keith G Hicks: "windows authentication question"
- In reply to: Dan Guzman: "Re: permission required for a backup operator"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
