Re: Backup permission
- From: "Matthew" <inetuser@xxxxxxxxxxx>
- Date: Mon, 24 Sep 2007 15:27:06 +1200
"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns99B34D40347EYazorman@xxxxxxxxxxxx
Matthew (inetuser@xxxxxxxxxxx) writes:
I have just added to an application I am working on the ability for theWithout know what you are doing, it's up to guesses, and the thought
user to create a backup of the database the application is connected to.
The backup works just fine, but prior to the backup I'd like to be able
to check that the user has BACKUP DATABASE, BACKUP LOG and CHECKPOINT
privileges so they won't potentially get a nasty error back from the
database server.
comes into mind is that the test users are members of the sysadmin
role.
It could help if you posted a script that demonstrtes the problem.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
The roles my test user was a member of seem to have been the problem. Once
I made sure they were only a member of the public role, the GRANT and DENY
privilege commands were reflected in queries on the PERMISSIONS() function
and the fn_my_permissions stored procedure.
.
- References:
- Backup permission
- From: Matthew
- Re: Backup permission
- From: Erland Sommarskog
- Backup permission
- Prev by Date: Re: Unauthorized IP address attached
- Next by Date: Re: sql server 2005 installation
- Previous by thread: Re: Backup permission
- Next by thread: Re: sa account Connections
- Index(es):
Relevant Pages
|
|
