Get the list of permissions of database object

• Deepthi Viswanathan Nair

  Old Hand

  Points: 392

  More actions

  September 22, 2007 at 1:05 pm

  #178640

  Comments posted to this topic are about the item Get the list of permissions of database object

  ---

  Kindest Regards,

  Deepthi Viswanathan Nair

• prao-569532

  Valued Member

  Points: 68

  More actions

  December 11, 2007 at 11:16 am

  #759103

  Hi,

  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 346

  There are no matching rows on which to report.

  Prasanna

• sreejithsql

  SSCommitted

  Points: 1813

  More actions

  January 23, 2008 at 2:19 pm

  #771051

  hi deepti,

  i too got same like prasanna.any modifiactions to be done?

  thx

  sreejith

  MCAD

• sayfrend

  SSCommitted

  Points: 1733

  More actions

  March 27, 2008 at 3:15 pm

  #794889

  Executed : exec sp_helprotect 'dbo.profiler'

  Result : "Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291

  There are no matching rows on which to report."

  Conclusion : What is this ?

  Note : I could exec sp_helprotect, with out any errors.

• srawant

  SSCommitted

  Points: 1829

  More actions

  October 27, 2008 at 4:43 pm

  #890331

  Hi Deepthi

  I need to list all the granular level permission of a user defined database roles. What do I do?

• tabinsc

  SSCommitted

  Points: 1812

  More actions

  December 19, 2013 at 8:17 am

  #1674841

  sayfrend (3/27/2008)

  ---

  Executed : exec sp_helprotect 'dbo.profiler'

  Result : "Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 291

  There are no matching rows on which to report."

  Conclusion : What is this ?

  Note : I could exec sp_helprotect, with out any errors.

  For the record, you get that error if there are no permissions defined for the object. I also noticed if the object has no permissions defined but the schema does, you still get the above error.

  I've actually found Red Gate's SQL Source Control to be a better option for viewing object permissions, since it gives you the GRANT statements you would execute.

  Tony
  ------------------------------------
  Are you suggesting coconuts migrate?

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 12, 2016 at 7:47 am

  #1878651

  Thanks for the script.