who is the owner..

From: dev (anonymous_at_discussions.microsoft.com)
Date: 05/18/04 

Date: Tue, 18 May 2004 10:51:15 -0700

Hi,

In various posts here and there I read that
1> if using SQL Authentication then instead of using the sa login to access the instance, we should create a new login (and it's new mapped user )and use it for our applications' interaction with the db.
2> that the dbo should remain the owner of the databases and also
3> that the owner of the database is the user who created it.

So if I follow 1> above then how can I ensure 2>. What is the way to achieve this. I mean to have my own login and user (let's talk about a system where my app talks to the db always as one user, for e.g. myuser) but still have dbo as the owner of my tables etc...

Am I making sense.

Thanks again.

Relevant Pages

  • Re: Security, Views, Multiple DBs
    ... the 'top' object is also mapped to the user that is the owner of the 'lower ... the same login, It's enough just to give your users permissions on the 'top' ... "Security Considerations for Cross-Database Ownership Chaining: ... highly-privileged users with data in other databases. ...
    (microsoft.public.sqlserver.security)
  • Re: Triggers
    ... Check the owner reported in the sp_helpdb output to ensure the databases ... EXEC sp_helpdb 'RegionalOffice' ... sp_changedbowner so that they are owned by a common login. ...
    (microsoft.public.sqlserver.security)
  • Re: bo-bo question
    ... You will as you have rightly stated need to change the owner of any ... databases the login owns. ... Also if the login owns jobs you will asked to ...
    (microsoft.public.sqlserver.security)
  • Re: Error 21776 - dbo account
    ... Maybe some of the other databases where you didn't change ... the owner are mapped to a login that does not exist on the ... change the owner to sa. ...
    (microsoft.public.sqlserver.security)
  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... detected that this login has permissions....etc this login ... be mapped to dbo. ... sysusers in the user databases and syslogins in master. ... I have seen a windows group referred to as a LOGIN for sql server in the ...
    (microsoft.public.sqlserver.security)