Post reply

PUBLIC role defaults to SELECT!?

  • June 11, 2009 at 4:52 am

    #205933

    Hi,

    When creating a new database I thought the PUBLIC role was default without any permission. For some reason I checked this and now I see the PUBLIC role automatically has SELECT rights in this database. When I add a new user, which is always a member of PUBLIC this user has SELECT rights on every usertable, can't do anything about it. I can manually change that, but I seem to recall this used to NOT be the case.

    Can any1 confirm PUBLIC indeed defaults to SELECT-rights? Is there a way to change this behaveour, besides writing my own logic for this?

    Greetz,
    Hans Brouwer

  • June 11, 2009 at 5:07 am

    #1007902

    http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/a7e6bcea-a593-4e29-939e-e76fe87dfce3

    Please see the above link can help.

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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