Re: Display Permissions
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Sun, 10 Feb 2008 14:46:52 +0200
Steven
Try also this one
SELECT *
FROM sysmembers membs
JOIN sysusers users on membs.memberuid = users.uid
JOIN sysusers groups on membs.groupuid = groups.uid
WHERE
users.name = @UserName
AND groups.name = @RoleName
"Steven" <Steven@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3D54F556-ED93-40A1-BA21-3DED9642F81E@xxxxxxxxxxxxxxxx
Anyone have sample queries that I can execute within Query Analyzer that
will
help me to quickly display the current permissions that each user has,
first
on a database, and then on the tables within that database?
.
- Prev by Date: Re: Can't remove user from role
- Next by Date: Re: SQL 2005 express security issue
- Previous by thread: Re: Display Permissions
- Index(es):
