Post reply

Public Role Access Query

  • August 30, 2007 at 7:29 am

    #180497

    I would like to make sure Public does not have access to stored and extended stored procedures. Is there a query I could use to do this?

    -Kyle

  • August 31, 2007 at 1:50 am

    #730668

    Kyle,

    if the stored procedures are in the database the database level permission EXECUTE should do the trick.

    DENY EXECUTE TO PUBLIC

    In case it has permissions to execute any stored procedures that start with sp_ and are in the master database (these are accessible in all databases), you will need to deny permission to these in the master database as well.

    Regards,

    Andras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

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

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