|
|
Posted by click37 on 09/05/07 17:19
On Aug 21, 5:31 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (clic...@gmail.com) writes:
> > Is there a query that will let me see what SQL users has what access
> > to which DBs and what lvl access they have?
>
> Not a single query, as the login-user mapping for a database is stored
> within it. You need to query each database, although this can be packaged
> with sp_MSforeachdb. I started to write something, but then it occurred
> to me that you had not said which version of SQL Server you are using.
> And the solution is completely different for SQL 2000 and SQL 2005.
>
SQL 2000. It doesn't need to be a stored prod, a developer that I
know created a tool that will allow me to run a query across all
servers & DBs. .
> As for "what access" and "what lvl", you need to be more specific. The
> permission scheme in SQL 2005 is very fine-grained, and the query could
> be very complex - as could the output be.
>
I need to know if each user has dbo rights, db_reader/writer and so
forth.
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|