Re: Roles & Users

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

  • Next message: Aaron [SQL Server MVP]: "Re: SQL database error?" 
    Date: Mon, 5 Jul 2004 12:50:49 -0700

    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
> >
> >
>
>
  • Next message: Aaron [SQL Server MVP]: "Re: SQL database error?"

    Relevant Pages

    • Re: Confused about dbo
      ... neither the explicit database owner or aliased to the dbo user. ... member of the db_owner role does not mean you are aliased to the dbo user. ... When you connect to SQL Server you do so using a login. ...
      (microsoft.public.sqlserver.security)
    • Re: Will anyone know this?
      ... You can determine if your login is the database owner with sp_helpdb. ... The only required user in a SQL Server database is dbo and this special ...
      (microsoft.public.sqlserver.security)
    • Re: db_owner role in SQL 2k
      ... Windows login name. ... login that is the owner of a database and members of the sysadmin role. ... >> the username dbo" ... >> FULL permission to do anything and everything. ...
      (microsoft.public.sqlserver.programming)
    • Re: db_owner role in SQL 2k
      ... The owner of a database is a login, which is listed in the sysdatabases ... I try not to think of DBO as the Database Owner, but just as special, ... For anyone to use any database, their login name must have been given access ...
      (microsoft.public.sqlserver.programming)
    • Re: db_owner role in SQL 2k
      ... > The owner of a database is a login, which is listed in the sysdatabases ... > table in the master database as the owner of the database. ... and their user name will ALWAYS be DBO. ... > automatically members of the public role. ...
      (microsoft.public.sqlserver.programming)