Re: GRANT BACKUP DATABASE

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 21:13:12 +0530

Hi,

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

Execute below procedure from query analyzer

use dbname
go
sp_helprotect null,'user_name'

The previlage "BACKUP DATABASE /BACKUP LOG" is identical to
db_backupopeartor role. Basically this fixed role is being assigned with
the BACKUP DATABASE /BACKUP LOG previlages internally.

Thanks
Hari
MCDBA

"CC&JM" <anonymous@discussions.microsoft.com> wrote in message
news:18e6301c44ca4$81008920$a601280a@phx.gbl...
> 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: T-SQL Debugger Error
    ... denied on object 'sp_sdidebug', database 'master', owner 'dbo'. ... and when I grant the permission of sp_sdidebug, ... I am using following statement to grant the permission. ...
    (comp.databases.ms-sqlserver)
  • RE: Security context of stored procedure
    ... Suppose there are three users in a database TEST_CHAIN, ... simple stored procedure: ... also grant it to test_sp2 ... SELECT permission denied on object 'authors', database 'test_chain', owner ...
    (microsoft.public.sqlserver.security)
  • GRANT BACKUP DATABASE
    ... I grant to one user the permission to backup one database ... grant backup database to bckusr ...
    (microsoft.public.sqlserver.server)
  • Re: SQL2005 grant user access to certain tables
    ... Then for each table that the user needs to read, give SELECT permission to ... Most good judgment comes from experience. ... We have a database on SQL2005 with 50 tables. ... We want to grant someone read table rights to only some tables. ...
    (microsoft.public.sqlserver.security)
  • Re: Security context of stored procedure
    ... It seems that cross database tables are completely blocked from stored ... > grant exec ... > simple stored procedure: ... SQL Server will not check the permission of the ...
    (microsoft.public.sqlserver.security)