Re: permission required for a backup operator

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 08/27/05 

Date: Sat, 27 Aug 2005 10:00:11 -0500

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.

Relevant Pages

  • Re: A question from a newbie
    ... Add the user to the db_datareader fixed database role. ... I support the Professional Association for SQL Server ... > Can somebody tell me the correct syntax if I want to grant SELECT ...
    (microsoft.public.sqlserver.security)
  • SQL2KSP4 sp_addalias and db_accessadmin
    ... A Member of the db_accessadmin Fixed Database Role Can Create an Alias ... for the dbo Special User" ... SQL Server 2000 Std Edition SP4 Japanese ...
    (microsoft.public.sqlserver.security)
  • Re: giving a user the ability to add logins and users to a database
    ... Add their login to the securityadmin fixed server role and to the ... db_accessadmin fixed database role. ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.security)
  • Re: Read only Permission and possibility to make views
    ... if you assign the sqllogin to db_datareader fixed database role, ... Rac v2.0 and ObjectScriptr @ new home ... > I worked with permissions in SQL server to grant access ...
    (microsoft.public.sqlserver.security)
  • Re: how to give a user permission to modify a view definition
    ... I think the user should be a member db_owner fixed database role. ... > We need to give a user a permission to modify the definition of a single ... > view in an SQL Server 2000 database. ...
    (microsoft.public.sqlserver.security)