Re: creating a login with only backup and alert rights

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 08:16:22 +0530

Hi,

Backup the database, You can assign the database wise role
"db_backupoperator"

How to assign the backup operator role to test user

1. Use database name
2. Execute sp_addrolemember db_backupoperator ,test

To create Alerts , the user should be the member of SYSADMIN fixed server
role.

Thanks
Hari
MCDBA

"robert" <rsalazar@cbbank.com> wrote in message
news:5190A3C1-E640-4F1C-BB84-8C242569ABFA@microsoft.com...
> What is the combination of rights to give a user access to only backup and
alerts.

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • Re: RMAN restore of full backup fails completely
    ... You are not using a catalog database. ... You might have autobackup controlfile on, ... Your autobackup has been made *prior* to the backup! ... plus archivelog', when i try a restore on the other server however, the ...
    (comp.databases.oracle.server)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)