SQL Server Performance Forum – Threads Archive
User "PUBLIC" in SQL 2005Hi, I am having difficulty to find a user called "Public" in SQL 2005. Can anyone help me where to find it? any info/help would greatly appreciate. Dan
Every database user belongs to the public database role. When a user has not been granted or denied specific permissions on a securable, the user inherits the permissions granted to public on that securable. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Satya, you can execute the script below with SQL 2005 loaded. You would see the "Puplic" user in Master database. I do not know where to find this "PUBLIC" user at. Thanks, Dan select sysusers.name, sysobjects.name, sysprotects.action from sysobjects, sysusers, sysprotects where sysobjects.id= sysprotects.id and sysprotects.uid = sysusers.uid and sysprotects.protecttype =205 and (sysprotects.action = 26 or sysusers.name = ‘public’ or sysusers.name = ‘guest’ or sysobjects.type = ‘S’)