Get the list of permissions of database object

  • Deepthi Viswanathan Nair

    Old Hand

    Points: 392

    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

    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

    hi deepti,

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

    thx

    sreejith

    MCAD

  • sayfrend

    SSCommitted

    Points: 1623

    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

    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

    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

    Thanks for the script.

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

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