Permissions button in Database User properties | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Permissions button in Database User properties

In sql 2000 when I need to find out which stored procs a specific user has EXEC permissions on, I simply click the nifty Permissions button in the user properties in EM.<br /><br />But MS 2005 does not provide this functionality. Is there a better way to get this info in SQL 2005 ?<br />[<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />]Thanks
Right click the procedure/Properties/then click permissions tab on the lef side…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Thanks
]]>