Re: Roles & Users

From: John Bell (jbellnewsposts_at_hotmail.com)
Date: 07/05/04 

Date: Mon, 5 Jul 2004 22:10:49 +0100

Hi

>From the original post I thought it was best not to go into detail, but (as
every) I will bow to your wisdom and point everyone to the following
excellent articles :)
http://www.winnetmag.com/Article/ArticleID/41773/41773.html
http://www.winnetmag.com/Article/ArticleID/40963/40963.html

John

"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:OUJwdlsYEHA.716@TK2MSFTNGP11.phx.gbl...
> I think just saying things like 'dbo is the database owner' can lead to a
> lot of confusion.
>
> DBO is simply a user name in a database, albeit a special, privileged one.
> It is the user name assumed by the login listed in sysdatabases as the
> database owner, as well as by any logins in the sysadmin role, or any
login
> who is aliased to the dbo user name.
>
> --
> HTH
> ----------------
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
>
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:#fHr8XsYEHA.2016@TK2MSFTNGP09.phx.gbl...
> > Hi
> >
> > dbo is the database owner. If you created the database and/or are a
member
> > of the sysadmin fixed server role all object that you create will be
owned
> > by the dbo. The is more information in books online, regarding logins,
> > users, permissions and roles. Rather than accessing the tables directly
it
> > is more secure to use stored procedures.
> >
> > Other places to start might be:
> > http://vyaskn.tripod.com/sql_server_security_best_practices.htm
> >
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> _security_05bt.asp
> > http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=22
> >
>
http://www.microsoft.com/sql/techinfo/administration/2000/security/securings
> qlserver.asp
> >
> > John
> >
> >
> >
> > "Paul King" <kin0363k@hotmail.com> wrote in message
> > news:ORNenyqYEHA.992@TK2MSFTNGP10.phx.gbl...
> > > Hi all,
> > >
> > > Can anyone help me please? I would really like to know how you setup
> > public
> > > access to a paricular database > table so that my ASPX script can
> display
> > > this information on the net.
> > >
> > > I have setup SQL with Windows Authenication but I only have one user
in
> > the
> > > Database called DBO.
> > >
> > > Any help would be appreciated.
> > >
> > > Thanks
> > > Paul
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: Roles & Users
    ... "John Bell" wrote in message ... >> I think just saying things like 'dbo is the database owner' can lead to ... >> It is the user name assumed by the login listed in sysdatabases as the ...
    (microsoft.public.sqlserver.server)
  • Re: db_owner role in SQL 2k
    ... Try not to say "If sa is THE dbo", it's like saying "If I am the joe". ... might help to either say "If sa is the database owner" or, ... The login 'sa' could be listed in sysdatabases as the database ... FULL permission to do anything and everything. ...
    (microsoft.public.sqlserver.programming)
  • Re: Two DB Owners
    ... full permissions in all databases. ... Note that the user will still be known as the 'dbo' user as long as the ... I need to add the login 'BUILTIN\Administrators' ... > 'DYNGRP' and 'BFGROUP' roles of the Dynamics and DAVCatalog databases. ...
    (microsoft.public.sqlserver.security)
  • Re: How do I set the login name for a user?
    ... You are better to make a dbo roled account (database god?), although that is not my first recommendation for connections. ... name, key name, without login. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: dbcreator and restore?
    ... I also created a backup after the login was set to ... dbo and that is the backup that i successfully restored. ... >SQL Server MVP ...
    (microsoft.public.sqlserver.security)