Home Forums SQL Server 2005 SQL Server 2005 Security Hide all system views/tables from users in SQL server 2005 RE: Hide all system views/tables from users in SQL server 2005

  • March 15, 2012 at 12:55 pm

    #1460098

    there's a number of threads here on SSC where the requirement is to remove public permissions in order to comply and lock down a SQL server to DoD standards (google Database Security Checklist for examples).

    In that ,we just don't care what breaks.

    see this thread for an example:

    http://www.sqlservercentral.com/Forums/Topic845604-392-1.aspx#bm845742

    and take a look at this link for a more comprehensive script.

    http://blogs.technet.com/b/fort_sql/archive/2010/02/04/remove-public-and-guest-permissions.aspx

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!