SQL Server Performance

User "PUBLIC" in SQL 2005

Discussion in 'SQL Server 2005 General Developer Questions' started by ForceF16, Jul 17, 2007.

  1. ForceF16 New Member

    Hi,

    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
  2. satya Moderator

    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.SQL-Server-Performance.Com
    @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.
  3. ForceF16 New Member

    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')

Share This Page