[dba-SQLServer]cross database ownership?

Francisco H Tapia my.lists at verizon.net
Wed Feb 4 19:33:58 CST 2004


How the heck does this work... I'm very puzzled.. I have SQL2000 w/ SP3 
and i'm realy grasping at straws right now as I can't seem to find the 
easiest solution for this...


I have an NT group in a role who has rights to sprocs on my database, 
They have execute rights but no table rights... however the sproc looks 
for data which spans across 2 databases

It does not make sense to me that I can't access the data in database 2 
especially since cross database ownership is turned on, on both databases.

the sproc is created by dbo, is there something else I need to do?  SO 
in the mean time I've added the user into both databases and into roles 
by the same name.. db_myRole in db1 and db_myRole in db2

now I get an error stating that the user dosen't have select rights on 
db2... this shouldn't be.for testing I gave the role rights to the table 
and still nothing
any ideas?  am I using cross database ownership wrong?  I'm about ready 
to yank the table into the first database.

-- 
-Francisco




More information about the dba-SQLServer mailing list