Re: View Permissions by User

If you can wait for SP2 (or get the CTP) then you can use a custom report
like this one or write one yourself
http://sqlblogcasts.com/blogs/sqldbatips/archive/2006/11/21/custom-ssms-reports-in-sp2-database-permissions.aspx

Screenshot here
http://sqlblogcasts.com/photos/sqldbatips/images/1383/original.aspx

--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com


"Brett Davis" <sqlsquirrel@xxxxxxx> wrote in message
news:%239KT$CWGHHA.1080@xxxxxxxxxxxxxxxxxxxxxxx
Hello..

How do I view permissions by user in SQL Server 2005. So for example in
SQL Server 2000, you go into a user database then users and right-click on
the user and select properties. From there you click the Permissions...
button in the upper right corner and that displays what permissions the
user has.

Please advise..

Thanks,

Brett




.