|
|
Browse by Tags
All Tags » Microsoft » SQL Server 2005 » T-SQL
-
Two days ago I posted a blog entry here that showed how the following SQL statement: select dp.NAME AS principal_name, dp.type_desc AS principal_type_desc, o.NAME AS object_name, ...
-
Today I was asked how one can query the server to list out all permissions that a principal has on all the securables in a SQL Server database. After 10 mins of searching through BOL I came up with the following that seems to work quite well: 1 select dp.NAME AS ...
|
|
|