944,132 Members | Top Members by Rank

Web Development > Databases > MS SQL > Cute: I need to remove the db_backupoperator permissions from the db_owner role.
Ad:
  • MS SQL Discussion Thread
  • Marked Solved
  • Views: 1168
  • MS SQL RSS
Permalink
Oct 28th, 2009
0

Cute: I need to remove the db_backupoperator permissions from the db_owner role.

Expand Post »
The reason is that :

1. I wish to run multiple databases on a single server.
To do this securely each login must be granted db_owner on the database so we can use "deny view any database" to hide the other databases from view. (login can see all databases they are owner of however).

2. This creates a problem. We do not wish the users to be able to create backups even though they are db_owners.
It's here that I am having difficulties.

Any ideas?
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
BratNZ is offline Offline
3 posts
since Oct 2009
Permalink
Nov 2nd, 2009
0
Re: Cute: I need to remove the db_backupoperator permissions from the db_owner role.
I assume you are running SQL Server 2005.
I far as i know it is not possible to change the permissions of a fixed database role (db_owner).
On database level try "DENY BACKUP DATABASE TO db-user" and "DENY BACKUP LOG TO db-user" where db-user is the database user (not the login!) who is member of the fixed database role "db_owner".
Reputation Points: 10
Solved Threads: 1
Newbie Poster
forjo is offline Offline
2 posts
since Nov 2009
Permalink
Nov 2nd, 2009
0
Re: Cute: I need to remove the db_backupoperator permissions from the db_owner role.
Click to Expand / Collapse  Quote originally posted by forjo ...
I assume you are running SQL Server 2005.
I far as i know it is not possible to change the permissions of a fixed database role (db_owner).
On database level try "DENY BACKUP DATABASE TO db-user" and "DENY BACKUP LOG TO db-user" where db-user is the database user (not the login!) who is member of the fixed database role "db_owner".
SQL2008 actually but those commands seemed to do the trick! Ta!
Reputation Points: 10
Solved Threads: 0
Newbie Poster
BratNZ is offline Offline
3 posts
since Oct 2009
Permalink
Nov 5th, 2009
0
Re: Cute: I need to remove the db_backupoperator permissions from the db_owner role.
That makes me happy, considering I didn't test it ...
Reputation Points: 10
Solved Threads: 1
Newbie Poster
forjo is offline Offline
2 posts
since Nov 2009

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: strong sa password error
Next Thread in MS SQL Forum Timeline: How to Create database in SQL Server using Javascript & HTML?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC