Objektberechtigungen anzeigen

DECLARE @string sysname;

SELECT @string = '< search string >';

SELECT
OBJECT_NAME(major_id) AS ObjectName,
USER_NAME(grantor_principal_id) AS Grantor,
USER_NAME(grantee_principal_id) AS Grantee,
p.permission_name
FROM
sys.database_permissions p
WHERE
OBJECTPROPERTY(major_id, 'IsMSSHipped') = 0 AND
USER_NAME(grantee_principal_id) = @string
ORDER BY
OBJECT_NAME(major_id), USER_NAME(grantee_principal_id), permission_name;
Noch kein Feedback
Einen Kommentar hinterlassen

Ihre E-Mail-Adresse wird nicht auf dieser Seite angezeigt.
SchlechtExzellent
(Zeilenumbrüche werden zu <br />)
(For my next comment on this site)
(Allow users to contact me through a message form -- Your email will not be revealed!)
Trackback-Adresse für diesen Eintrag

http://www.insidesql.org/blogs/htsrv/trackback.php?tb_id=951