Posted by SQL Server on 01/20/08 01:17

On Jan 19, 5:51 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> SQL Server (alderran...@gmail.com) writes:
> > Is there a built in stored procedure that would allow me to list out
> > the database permissions assigned to a particular user or role?
>
> Not really. Rather you are best off querying the view
> sys.database_permissions. You can also use fn_my_permissions and
> has_perms_by_name, but you would first need to impersonate the user in
> question.
>
> All the above applies to SQL 2005 only. There were big overhaul of
> security in SQL 2005.
>
> Make it a habit to always specify which version of SQL Server you are using
> when you ask questions.
>
> --
> 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

It's SQL 2005... Thanks!

• Next in forum: Access 2000 and SQL Server 2005
• Prev in forum: Re: Stored Procedure to list out user access
• Thread view: Re: Stored Procedure to list out user access

[Reply to this message]