PUBLIC role is missing in SQL Server 2005

Question

In Sql Server 2005, PUBLIC role is missing.  How can I get back this role?  Please help me on this.

Regards,

Kiran

Answer 1

Is it at the server level or the Database level ?
By the way , what is your SQL server 2005 service pack and your SSMS version ?

---

Thanks, Leks

Answer 2

every database user automatically belong to the fixed public role,  and every SQL Server login belongs to the public server role. They can't be missing. 

I guess you can't find public through SSMS sometime, but it exist indeed.
what's the symptom of your database and please run following query to check
select * from sys.server_principals where name='public'

select

 

* from sys.database_principals where name='public'

---

有dba的职位吗

Answer 3

<<I guess you can't find public through SSMS sometime, but it exist indeed.>>

That would be my guess as well. At some version, SSMS didn't show the public server role. But not displaying it doesn't really make any functional difference.

---

Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi