Cross database ownership chaining question

Do we need to worry about the default SP3 service pack upgrade which has
cross database ownership chaining disabled of all our objects on all
databases are owned by dbo.Using SQL 2000The cross-database ownership chaining option is only needed if you have
cross-database object references and users don't have permissions on the
referenced objects. If you have problems after disabling this option, you
can either turn it on selectively in the databases involved or grant direct
permissions on the referenced objects.
Note that your databases are not owned by 'dbo' - databases are owned by
logins (e'g' 'sa'). In order to maintain an unbroken cross-database
ownership chain for dbo-owned objects, the databases involved must be owned
by the same login.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:eG1vClmyDHA.2156@.TK2MSFTNGP09.phx.gbl...
> Do we need to worry about the default SP3 service pack upgrade which has
> cross database ownership chaining disabled of all our objects on all
> databases are owned by dbo.Using SQL 2000
>|||Is there some scripts that I can download to demonstrate this ?
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:e3iiH5myDHA.1744@.TK2MSFTNGP12.phx.gbl...
> The cross-database ownership chaining option is only needed if you have
> cross-database object references and users don't have permissions on the
> referenced objects. If you have problems after disabling this option, you
> can either turn it on selectively in the databases involved or grant
direct
> permissions on the referenced objects.
> Note that your databases are not owned by 'dbo' - databases are owned by
> logins (e'g' 'sa'). In order to maintain an unbroken cross-database
> ownership chain for dbo-owned objects, the databases involved must be
owned
> by the same login.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:eG1vClmyDHA.2156@.TK2MSFTNGP09.phx.gbl...
> > Do we need to worry about the default SP3 service pack upgrade which has
> > cross database ownership chaining disabled of all our objects on all
> > databases are owned by dbo.Using SQL 2000
> >
> >
>|||This KB article contains some scripts:
http://support.microsoft.com/default.aspx?scid=kb;en-us;272424&Product=sql2k
There is more info about cross db ownership chaining here:
http://support.microsoft.com/default.aspx?scid=kb;en-us;810474&Product=sql2k
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u6#BmQqyDHA.540@.tk2msftngp13.phx.gbl...
> Is there some scripts that I can download to demonstrate this ?
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
> news:e3iiH5myDHA.1744@.TK2MSFTNGP12.phx.gbl...
> > The cross-database ownership chaining option is only needed if you have
> > cross-database object references and users don't have permissions on the
> > referenced objects. If you have problems after disabling this option,
you
> > can either turn it on selectively in the databases involved or grant
> direct
> > permissions on the referenced objects.
> >
> > Note that your databases are not owned by 'dbo' - databases are owned by
> > logins (e'g' 'sa'). In order to maintain an unbroken cross-database
> > ownership chain for dbo-owned objects, the databases involved must be
> owned
> > by the same login.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:eG1vClmyDHA.2156@.TK2MSFTNGP09.phx.gbl...
> > > Do we need to worry about the default SP3 service pack upgrade which
has
> > > cross database ownership chaining disabled of all our objects on all
> > > databases are owned by dbo.Using SQL 2000
> > >
> > >
> >
> >
>