Post reply

Public Role

  • April 8, 2008 at 1:01 pm

    #121234

    This is actually very simple but I never thought about it how it works

    In every User Database for any login Public Role is selected.

    What if user has DBO access and I take away public role?

    What exatcly public roles does?

  • April 8, 2008 at 1:35 pm

    #799987

    You can not remove public role for login..you will get an error.

    If you want to control access you can grant\revoke permissions to public role and hence that login..

    NJ

  • April 9, 2008 at 9:57 pm

    #800749

    Every user with permission to connect to the database is a member of the public role. Permissions granted to the public role would then be granted to anyone who can enter the database. Because of this, it is generally frowned upon to grant any additional access to public than what it already has by default.

    K. Brian Kelley
    @kbriankelley

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

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