Home Forums SQL Server 2008 T-SQL (SS2K8) Enable 'Allow modifications to be made directly to the system catalogs' RE: Enable 'Allow modifications to be made directly to the system catalogs'

  • First thanks for the reply,

    Secondly I am trying to delete access to Object Permissions for the public user. (I am not worried about the side affects, it has to be done) The SQL comman I am using deletes all of the Object Permissions for public accept 26 Now I have read that if I dont enable the Allow modifications to be made directly to the system catalogs' I cant delete them all and I am assuming this is the problem which I am facing. Is there a work around in 2005 or Am I just screwed?