Re: Roles & Users

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 07/06/04 

Date: Mon, 5 Jul 2004 23:06:54 -0700

It's fine not to go into detail. But some simplifications can actually make
it harder to understand the full story when one is ready to do so.
And those links are probably more detail than anyone needs right now. ;-) 

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:#nlacQtYEHA.2216@TK2MSFTNGP10.phx.gbl...
> 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: Event ID 28005; Error 15517
    ... If this database was restored from another server, the login that is the ... database owner (and therefore the login that becomes dbo) does not exist on ... try changing the database owner by running: ...
    (microsoft.public.sqlserver.security)
  • Re: Roles & Users
    ... John ... > 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 ...
    (microsoft.public.sqlserver.server)
  • Re: Roles & Users
    ... 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 ...
    (microsoft.public.sqlserver.server)
  • Re: Accidentally dropped DBO from database
    ... You can use sp_changedbowner and dbo will map to whatever ... login you assign as the database owner with ... >changes an AND to an OR so that the user DBO was dropped after a refresh from ...
    (microsoft.public.sqlserver.security)
  • 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)