Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 650
  • Last Modified:

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

Hi Experts,
I am trying to create the public role. It seems to be missing on the server. How do I find/ create it?
2 Solutions
Dave BaldwinFixer of ProblemsCommented:
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 http://blogs.msdn.com/b/lcris/archive/2007/09/12/basic-sql-server-security-concepts-permissions-and-special-principals-sa-dbo-guest.aspx and several others say you can cause problems by changing the 'public role'.
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



Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now