Post reply

Get the list of permissions of database object

  • 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

  • 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

  • January 23, 2008 at 2:19 pm

    #771051

    hi deepti,

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

    thx

    sreejith

    MCAD

  • 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.

  • 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?

  • 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?

  • May 12, 2016 at 7:47 am

    #1878651

    Thanks for the script.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply