Home Forums SQL Server 7,2000 Security Can all permissions to Public role be safely removed? RE: Can all permissions to Public role be safely removed?

  • Short answer, no. Microsoft made minimal changes to earn a C2 compliance standard. Public was largely unaffected.

    SQL Server 2000 C2 Administrator's and User's Security Guide

    If you want more details, my GSEC practical looked at this issue...

    SQL Server 2000: Permissions on System Tables Granted to Logins Due to the Public Role

    K. Brian Kelley
    @kbriankelley