Re: Master db security

From: Uri Dimant (urid_at_iscar.co.il)
Date: 05/24/05 

Date: Tue, 24 May 2005 15:25:30 +0300

Jack
You cannot deny access to the public role .See sp_revokedbaccess system
stored procedure does the job for you.

"Jack Dale" <jackdale10@yahoo.com> wrote in message
news:OOiz%23oFYFHA.1040@TK2MSFTNGP10.phx.gbl...
> Hi,
>
> I want to secure the master database so that no users that have dbo roles
in
> other databases on the server have access to tables etc. that they don't
> need access to. Can I just deny access to the public role for each table
and
> sp or are there some that all users need access to? Does anyone know of a
> script to tighten the security on the master db?
>
> thanks - jack
>
>

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)
  • Can I Hide system sp,view,tables to public role?
    ... I have discovered that any user with only public role can ... multiple databases (eg executing sp_who, ... is possible deny access to system views ... that having dangerous informations? ...
    (microsoft.public.sqlserver.security)
  • What exactly can PUBLIC ROLE do in SqlServer?
    ... I need to know what exactly a PUBLIC ROLE is capable of ... gathered info about PUBLIC. ... really capable of doing in Master database? ... standards for SqlServer in our organisation. ...
    (microsoft.public.sqlserver.security)
Loading