What exactly can PUBLIC ROLE do in SqlServer?

From: Kanthi Mathi (kanthi_mathi@hotmail.com)
Date: 03/29/03 

From: "Kanthi Mathi" <kanthi_mathi@hotmail.com>
Date: Sat, 29 Mar 2003 00:34:28 -0800

Hi all,

I need to know what exactly a PUBLIC ROLE is capable of
doing in Master database. I issued sp_helprotect and
gathered info about PUBLIC. Sp_helprotect does give the
list of SPs that PUBLIC can execute, but when I test them,
they fail because PUBLIC doesn't have the required
permissions on their corresponding tables.

Does anybody have the list of activities that PUBLIC is
really capable of doing in Master database?

I am looking for this info to define the security
standards for SqlServer in our organisation.

Thanks a lot for all your help.

Relevant Pages

  • RE: ODBC+MFC; CRecordset::Update() syntax error or access violation
    ... > The problem described below uses the Patient table as an example. ... > //The recordset opens fine and retrieves the right record. ... > Everything was working fine until the select permission on the public role ... > It seems that the MFC recordset is trying to acceess the master database ...
    (microsoft.public.data.odbc)
  • ODBC-MFC CRecordset::Update() Syntax error or access violation
    ... select rights on the sysdatabases and the CRecorset::Updateis invoked. ... //We are connecting to the database using ODBC (DSNless connection) TCP/IP ... Everything was working fine until the select permission on the public role ... permission for the public role for sysdatabases table in master database is ...
    (microsoft.public.vc.database)
  • Re: Master db security
    ... You cannot deny access to the public role .See sp_revokedbaccess system ... > I want to secure the master database so that no users that have dbo roles ...
    (microsoft.public.sqlserver.security)
Loading