Minimum SQL permissions?

Documents SQL Server 2000, 2005 and 2008 databases.


Moderators: David Atkinson, david connell, Charles Brown

Minimum SQL permissions?

Postby FISsql » Tue Jun 12, 2007 7:53 pm

I am trying to create a SQL Login that allows a user to create all the necessary SQL Docs for databases, tables, stored procedures, etc., but I want to limit their ability on the actual SQL Server.

What would be the minimal permission settings needed to create the SQL Docs?

Thanks
FISsql
 
Posts: 1
Joined: Tue Jun 12, 2007 7:39 pm

Postby Brian Donahue » Wed Jun 13, 2007 9:37 am

Hi,

The safest thing to do on SQL 2005 is to GRANT VIEW DEFINITION to your documentation user. Then even if the user is not allowed access to some objects in the database, there should be a guarantee that they can still access all of the schema definitions.

You may need some additional rights if you are going to place 'comments' on objects.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Doc 1

Who is online

Users browsing this forum: No registered users and 2 guests