Post reply

Viewing system objects.

  • June 18, 2004 at 10:55 am

    #82998

    I'm new to SQL Server administration and need to know how to turn-on [off] viewing of system tables and stored procedures per user or login. THX.

     

  • June 18, 2004 at 11:51 am

    #511093

    Any user is a member of the public role in the database. The public role is granted access to many of the system tables.But You might want to be careful in revoking access to the public role as this can break lot of stuff. Below is an excellent article from Brian Kelly.

    http://www.giac.org/practical/GSEC/KBrian_Kelley_GSEC.pdf

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

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