Haslett, Andrew
andrew.haslett at ilc.gov.au
Wed Feb 4 20:19:06 CST 2004
Have you set up a linked server? Or using an adhoc connection? -----Original Message----- From: Francisco H Tapia [mailto:my.lists at verizon.net] Sent: Thursday, 5 February 2004 12:04 PM To: SQL Server 2k List; dba-SQLServer at databaseadvisors.com Subject: [dba-SQLServer]cross database ownership? 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com IMPORTANT - PLEASE READ ******************** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not.