Re: new userID can do all...

From: Denny (mrdenny@gamespy.com)
Date: 02/06/03 

From: "Denny" <mrdenny@gamespy.com>
Date: Thu, 6 Feb 2003 10:41:23 -0800

Being in the public role in a database shouldn't give you access to do
anything other than connect to the database. Make sure no one gave the
public role read and write access to the database. 

--
Denny Cherry
Database Administrator
GameSpy Industries
"Rob" <rhchin@hotmail.com> wrote in message
news:064801c2cdff$786a9280$cef82ecf@TK2MSFTNGXA08...
> The ID has been created with SQL authentication. It's not
> a NT/2000 user account. Could this be because of this user
> belongs to the public role?
>
> The public role's default permissions weren't changed.
>
> Thanks.
>
> >-----Original Message-----
> >Good point.  I forgot about that.
> >
> >--
> >Denny Cherry
> >Database Administrator
> >GameSpy Industries
> >
> >"K. Brian Kelley" <nospam@warpdrivedesign.org> wrote in
> message
> >news:Xns9319AF66834C3KBK@207.46.248.16...
> >> "Rob" <rhchin@hotmail.com> wrote in news:09ac01c2cd60
> $c3fb3550
> >> $89f82ecf@TK2MSFTNGXA01:
> >>
> >> > No server roles have been assigned. Thanks.
> >> >
> >>
> >> Does he have administrative rights to the box
> (including being a member
> >> of Domain Admins)? If so, is BUILTIN\Administrators
> still present with
> >> sysadmin rights (read up before you consider removing
> it, there are some
> >> KB articles that detail the issues)?
> >>
> >> --
> >> K. Brian Kelley
> >> Author of Start to Finish Guide to SQL Server
> Performance Monitoring
> >> SQLServerCentral.com Columnist
> >> http://www.truthsolutions.com/
> >
> >
> >.
> >

Relevant Pages

  • Re: PUBLIC ROLE
    ... think of the Public role as being very much ... > If I create a database called "TEST" and make a user George database ... you grant those permissions to the public role. ...
    (microsoft.public.sqlserver.security)
  • Re: Public Role in SQL Server 2000 SP3
    ... The public role is a special database role to which every database user ... Captures all default permissions for users in a database. ... Hari is a database owner and he create a table customer. ...
    (microsoft.public.sqlserver.server)
  • Re: Remove permissions in default Public Role?
    ... functionality. ... in a database or when connecting to a database server. ... You'd want to make sure you are not granting permissions to ... happening because of the Public Role in the Master db. ...
    (microsoft.public.sqlserver.security)
  • Re: Remove permissions in default Public Role?
    ... amount of meta data and system functions that all users ... in a database or when connecting to a database server. ... You'd want to make sure you are not granting permissions to ... happening because of the Public Role in the Master db. ...
    (microsoft.public.sqlserver.security)
  • 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 ...
    (microsoft.public.data.odbc)