GRANT BACKUP DATABASE

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: CC&JM (anonymous_at_discussions.microsoft.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 08:31:29 -0700

Hello,

I grant to one user the permission to backup one database
but now i cant check what permissions has that user.

ex: grant backup database to bckusr
    grant backup log to bckusr

I test to backup one database with this user account and
got no problem but i supposed that when i grant the user
the "BACKUP DATABASE" permission the user will be added to
the db_backupoperator database role.

Can you explain me this.

Best regards

Relevant Pages

  • Re: GRANT BACKUP DATABASE
    ... I grant to one user the permission to backup one database but now i cant ...
    (microsoft.public.sqlserver.server)
  • Re: Microsoft Access
    ... Restore from backup? ... > My former instructor came to my office trying to show how to mail merge ... Now I cannot access my database. ... > message - you do not have permission to use object. ...
    (microsoft.public.windowsxp.security_admin)
  • 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)