Post reply

Deleting Public Permissions from Master Dataase

  • January 11, 2010 at 10:16 am

    #208930

    Hey,

    So I am trying to delete all the public permissions from my database. All my code works fine and I cant delete most of the thousand + Select and Execute permissions execpt for 26. Its telling me that they don't exist or I don't have permissions ... clearly they exist. Something I read suggested that you must enable 'Allow modifications to be made directly to the system catalogs'. However, I cant seem to find a way to implement this in the SQL? Would someone know how to do this?

    Thanks,

  • January 11, 2010 at 10:40 am

    #1101934

    first, deleting all public permissions from master could cause you issues. There are procs in that that a normal user might need to access.

    Second, what is "26"? What code are you trying to run?

  • January 11, 2010 at 10:49 am

    #1101937

    26 is ther number of Object permissions that I cant delete. There is a set number every time that it is installed I was hoping, it might help. Im running this in SQL Server Management studio Express. Im not worried about the side effects.

    Thanks

  • January 11, 2010 at 10:06 pm

    #1102171

    Just noting that Lowell answered this question nicely on another thread by falcon59x.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

Viewing 4 posts - 1 through 3 (of 3 total)

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