var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Cross database ownership sanity check
I'm seeking some clarification help
SQL2000 w/ SP3
Cross DB Ownership Chaining run_value == 1 ( rebooted )
in database DB1
user cdb_test creates table t
in database DB2
user cdb_test creates view 'test' as
select * from DB1..t
so far so good.
in DB2, user cdb_test grants cj_rb SELECT on test.
when user cj_rb tries a select * from cdb_test.test
I get "user cj_rb is not a valid user in DB1"
yes, DB1 (one)
as soon as I sp_adduser cj_rb to DB1 ( even w/o granting any permissions ), the select from the view works.
why?? or did i miss a configuration somewhere??