Re: Creating specific users
- From: "Mike" <no@xxxxxxxxx>
- Date: Thu, 26 Apr 2007 10:10:15 +0100
Hi,
The minimum rights a user account needs is:
Public (can not remove)
db_backupoperator
db_denydatareader (don't need but locks down)
db_denydatawriter (don't need but locks down)
If db_denydatareader is not set the user will be able to see the tables and
the structure (table properties only), but not the data in the tables. See
the stored procedures and views there content but cannot edit them. When
selected it will hide all the tables, views, stored procedures and users
from them and they will only be able to backup the database.
The only issue you will have is if they are backing up to disk they will not
be able to browse the DIR structure but can enter the location manually.
Alternatively you can set it up as a backup device.
- Mike
---------------------------------------------------------------------------------
<a href="http://www.cogitar.net";> Cogitar Software. (
http://www.cogitar.net ) </a>
http://www.cogitar.net Cogitar Software. (Software Development and Managment
Systems)
http://www.web-dominion.co.uk Web-Dominion. (Web Design and hosting )
http://shop-dominion.com (senery landscape pictur gallery)
---------------------------------------------------------------------------------
"Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1A221F70-5B21-4A76-97DF-4BF62A4E4196@xxxxxxxxxxxxxxxx
I have a user who is just responsible for monitoring SQL backups. However I
seem to have to grant sys admin rights in order for the user to be able to
see the backups in Enterprise manager. What is the lowest level that I can
grant to the user in this situation ?
Si
.
- Prev by Date: Re: SQL 2005 SP
- Next by Date: RE: View SQL Diagrams if user has view definition rights via domai
- Previous by thread: Re: Creating specific users
- Next by thread: Re: create\alter sp in schema privilage
- Index(es):
Relevant Pages
|
