SQL Server Performance Forum – Threads Archive
Permissions button in Database User propertiesIn 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=’‘ />]Thanks
Right click the procedure/Properties/then click permissions tab on the lef side…
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.