Re: Triggers

From: Dan Guzman (danguzman@nospam-earthlink.net)
Date: 01/28/03 

From: "Dan Guzman" <danguzman@nospam-earthlink.net>
Date: Mon, 27 Jan 2003 19:04:47 -0600

Check the owner reported in the sp_helpdb output to ensure the databases
are owned by the same login:

EXEC sp_helpdb 'MainOffice'
EXEC sp_helpdb 'RegionalOffice'
GO

If the reported owners are different, you'll need to execute
sp_changedbowner so that they are owned by a common login. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
-----------------------
SQL FAQ links (courtesy  Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
-----------------------
"g..g" <grace_atrash@yahoo.com> wrote in message
news:#eRLF7ixCHA.640@TK2MSFTNGP12...
> Hi dan:
> Thank You for the response. But I have sqlms7 with dbo as the owner of
both
> databases.
> However, I still get the message access denied. Please HELP.
> Thank YOu,
> Grace

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)
  • who is the owner..
    ... 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. ...
    (microsoft.public.sqlserver.msde)
  • 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: Permissions and ODBC
    ... objects have the same owner. ... case of dbo-owned objects in different databases, ... See the SQL 2003 SP3 Books Online for more ... > The Ms Access program executes a stored procedure that resides in SQL ...
    (microsoft.public.sqlserver.server)