SQLServerCentral / Discuss content posted by Deepthi Viswanathan Nair / Article Discussions / Article Discussions by Author / Get the list of permissions of database object / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 21:29:29 GMT20RE: Get the list of permissions of database objecthttp://www.sqlservercentral.com/Forums/Topic401452-444-1.aspxHi DeepthiI need to list all the granular level permission of a user defined database roles. What do I do?Mon, 27 Oct 2008 16:43:53 GMTsrawantRE: Get the list of permissions of database objecthttp://www.sqlservercentral.com/Forums/Topic401452-444-1.aspxExecuted : exec sp_helprotect 'dbo.profiler'Result : "Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291There are no matching rows on which to report."Conclusion : What is this ?Note : I could exec sp_helprotect, with out any errors.Thu, 27 Mar 2008 15:15:06 GMTsayfrendRE: Get the list of permissions of database objecthttp://www.sqlservercentral.com/Forums/Topic401452-444-1.aspxhi deepti, i too got same like prasanna.any modifiactions to be done?thxsreejithMCADWed, 23 Jan 2008 14:19:25 GMTSreejithsqlRE: Get the list of permissions of database objecthttp://www.sqlservercentral.com/Forums/Topic401452-444-1.aspxHi, I cannot execute this statement. sp_helpprotect is not found in the docs. I get this msg on 2000 and 2005. sp_helprotect 'KROLL_DELTEKCP.PS_DETAIL' Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346There are no matching rows on which to report.PrasannaTue, 11 Dec 2007 11:16:38 GMTprao-569532Get the list of permissions of database objecthttp://www.sqlservercentral.com/Forums/Topic401452-444-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Miscellaneous/31990/">Get the list of permissions of database object</A>[/B]Sat, 22 Sep 2007 13:05:17 GMTDeepthi Viswanathan Nair