Post reply

Revoke permission issues

  • December 16, 2005 at 2:45 am

    #170042

    Hi all,

    I need to revoke all the permission from guest user in master database.

     

    Thanx in advance

    from

    Killer

  • December 19, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • December 19, 2005 at 1:27 pm

    #610426

    in 2005 you can accomplish this in SSMS (Management Studio) by going to database || system databases || master >> Permissions, Guest and checking deny on each permission.  By default they only have "connect".  My memory of 2000 is too distant to respond  Hope this helps.

    Cheers,

    david russell

  • December 19, 2005 at 1:30 pm

    #610428

    very good point in your other thread... you would also need to handle "public"

    Cheers,

    david russell

  • December 20, 2005 at 8:40 am

    #610600

    Will this help you?

     

    exec sp_revokedbaccess 'username'

     

    Get busy living ....or get busy dying....

  • December 20, 2005 at 9:43 am

    #610638

    I answered this in another posting of raj's. You cannot revoke access to the guest user in either master or tempdb. Bad things happen (Chris Leonard did this to test what would happen but I can't seem to find the thread). In any case, you can revoke most of the permissions public has access to, but you've got to be careful not to revoke permissions to spt_values and sp_MShasdbaccess.

    K. Brian Kelley
    @kbriankelley

  • December 20, 2005 at 8:33 pm

    #610757

    Thanx bkelley.

     

    I understood what u where trying to say.

    from

    Killer

Viewing 7 posts - 1 through 6 (of 6 total)

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