Re:Enterprise Manager and Windows Account

From: Vishal Parkar (vgparkar@hotmail.com)
Date: 11/29/02 

From: "Vishal Parkar" <vgparkar@hotmail.com>
Date: Thu, 28 Nov 2002 20:52:18 -0800

If you want to grant only backup role add him to the
following database role.

db_backupoperator

this will allow a user to perform DBCC,Backup operations.
see bol for more information on this. You can add him to
db_denydatareader role as well to keep him away from
reading any table.

--Vishal

>-----Original Message-----
>Dear All,
>
>I wanted to a samll question about security in enterprise
manager and normal
>user accounts.
>
>I have SQL2k on win2k server and normally all
administration work is the
>carried out using administrator account. my manage wants
to give backup and
>restore task to a newly hired person in our organization,
but he do not want
>to give the admin password to him
>
>His account is in the USERS group in Win2k
>
>I have to add the user (with his login) in the required
database and assign
>him the backup operator role.??
>
>I also want to know if i give him backup operator role
can he access the
>data in tables by opening them in EM?
>
>an early response will be highly appreciated.
>
>kind regards
>Tabassum
>
>
>.
>

Relevant Pages

  • Re: permission required for a backup operator
    ... I have fixed the user as an db_backupoperator database role and I still have ... I have tried creating a backup device ... pointing to the tape but the operator still can't see it. ... "Dan Guzman" wrote: ...
    (microsoft.public.sqlserver.security)
  • Re: permission required for a backup operator
    ... What is the exact error message? ... Any related messages in the SQL Server ... Can the user backup to disk? ... >> method is to add the user to the db_backupoperator fixed database role. ...
    (microsoft.public.sqlserver.security)
  • Re: User authentication
    ... I have to maintain separate account management. ... If I use Windows backup ... However, if possible, I would like to use Windows authentication as opposed ...
    (microsoft.public.sqlserver.clients)
  • Re: Changed Name & Lost Access
    ... where xxxyyyzzz is the new password for the thomas account. ... internal disk protects you against about 30% of the usual ... backup system is one that has the backup medium kept ...
    (microsoft.public.win2000.general)
  • Re: Removing old transaction log backup files
    ... This is likely to be either a permissions problem or a sharing violation ... account is the security context for jobs, ... delete an expired backup. ... SQLServerAgent startup account is LocalSystem, ...
    (microsoft.public.sqlserver.server)