GRANT BACKUP DATABASE

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 regardsHi,
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