Re: Stored Proc rights and joinning to another database
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 02/26/04
- Next message: Kofi: "Distributed Stored Procedures"
- Previous message: Tibor Karaszi: "Re: Back up File Location"
- In reply to: Joel: "Stored Proc rights and joinning to another database"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 16:30:27 +0100
If the databases and tables has the same owner, you can get by. But that
requires lowering the security. As of sp3, you have to enable cross-database
chaining in order to allow this. See the readme for sp3 for more
information.
-- Tibor Karaszi, SQL Server MVP Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver "Joel" <anonymous@discussions.microsoft.com> wrote in message news:E0E6F54C-04AC-49AB-AF07-744521B83C1F@microsoft.com... > Hi! I have a little problem with one of my Stored Proc. I don't give any rights to my users on tables but I give execute rights on my Stored Procedures. I'm doing a join on another database (dbo.Orders inner join MS.dbo.Employee) in my stored proc but I have to give Select rights to my users on the table and I don't want to do that. Is there another solution? > Thanks Joel :) >
- Next message: Kofi: "Distributed Stored Procedures"
- Previous message: Tibor Karaszi: "Re: Back up File Location"
- In reply to: Joel: "Stored Proc rights and joinning to another database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
