Can't find/create Public role on SQL Server 2005

Posted on 2012-08-15
Last Modified: 2012-08-30
Hi Experts,
I am trying to create the public role. It seems to be missing on the server. How do I find/ create it?
Question by:DTinCT
    LVL 82

    Accepted Solution

    If you search for "Public role on SQL Server 2005", you will find a lot of posts that say that it can not be removed but that it may not show up in things like SMSS.  This article and several others say you can cause problems by changing the 'public role'.
    LVL 9

    Assisted Solution

    the public role is at the database level, not at the server level.
    so, you have to revoke that on each database

    Public is a database role. When you add a login you add that to the sql server instance. you can map it to the public role when you add the login to the database user.
    you can also check it using

    select * from sys.server_principals where name='public'

    also refer below links for ref

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now