[dba-SQLServer]cross database ownership?

what in what

My situation, I have an audit data that I thought would be useful in 
it's own database.  Is this not the way to do it? keep the archived info 
seperate? or simply moving it to it's on filegroup?

db1 = data
db2 = archive

I wanted to be able to exec a sproc in db1 but that doesn't seem like 
it's gonna happen,

It seems I'll need to create the sproce for read and write in db2 and 
handle all rights there?

-- 
-Francisco

Djabarov, Robert wrote:

> It is also BAD practice to have a design that is not thought through so that the administration of the application becomes a nightmare or too cumbursome to support.  Related things need to be kept together (IMHO)
> 
> 	-----Original Message----- 
> 	From: dba-sqlserver-bounces at databaseadvisors.com on behalf of Francisco H Tapia 
> 	Sent: Fri 2/6/2004 8:37 PM 
> 	To: dba-sqlserver at databaseadvisors.com 
> 	Cc: 
> 	Subject: Re: [dba-SQLServer]cross database ownership?
> 	
> 	
> 
> 	Granted...
> 	
> 	However it is generally BAD practice to give an enduser rights to
> 	tables... thus... if said user is in db1 and belongs to role1 and that
> 	role1 is given excute rights to sproc1 wich basically says
> 	
> 	
> 	Select field1, field2 from db1.dbo.table1 t1 inner join db2.dbo.table2
> 	t2 ON t1.field1 = t2.field2
> 	
> 	How can I make this work?
> 	
> 	both db1 and db2 have db chaining turned on, however it is still
> 	generating errors that my users dont have select rights in db2.
> 	
> 	should I make a view in db2 and give them select rights there, and join
> 	back via a view instead?
> 	
> 	
> 	thanks for any suggestions
> 	
> 	
> 	Djabarov, Robert wrote:
> 	
> 	> This behavior is by design, otherwise users that are not present in 1
> 	> database could have access to it from another database.  That would not
> 	> be pretty :)
> 	>
> 	> -----Original Message-----
> 	> From: dba-sqlserver-bounces at databaseadvisors.com
> 	> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of
> 	> Francisco H Tapia
> 	> Sent: Thursday, February 05, 2004 5:27 PM
> 	> To: dba-sqlserver at databaseadvisors.com
> 	> Subject: Re: [dba-SQLServer]cross database ownership?
> 	>
> 	>
> 	> I have that but it still doesn't resolve when the user is only a member
> 	> of one database
> 	> it's not until I make them members of the 2nd database that it does it
> 	> right.
> 	>
> 	
> 	
> 	--
> 	-Francisco
> 	
> 	_______________________________________________