How to  check all sp  permission in sql2000

Posted on 2009-04-20
Last Modified: 2012-08-13
I would like to know in Sql2000 how do we check what permission has in each sp? I know that this possible via EM, but this require me to check one by one, how about T-sql?
Question by:motioneye
    LVL 31

    Accepted Solution

    --List all user permissions of all Database objects
    USE dbName
    -- List all user permissions of a table
    USE dbName
    sp_helprotect 'tableNme'
    -- List all user permissions of stored procedure
    USE dbName
    exec sp_helprotect 'spName'
    -- List all user permissions of sp granted by dbo
    USE dbName
    sp_helprotect 'spName', null,dbo
    -- List all Object type user permissions
    USE dbName
    sp_helprotect null, null,null,'o'
    -- List all statement type user permissions
    USE dbName
    sp_helprotect null, null,null,'s'

    Author Comment

    sp_helprotect ner to close  to help me, what I'm looking for is any sp or T-sql which able to list me all only sp with permissions status ad other objects such extend procedures,tables will not require

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now