Re: using same procedure in different database users
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 28 Jan 2003 12:42:24 +0100
Message-ID: <1043754051.657148_at_news.thyssen.com>
Date: Tue, 28 Jan 2003 12:42:24 +0100
Message-ID: <1043754051.657148_at_news.thyssen.com>
Hi Gourav,
first of all: every user (*database* user) has its *own* schema.
What do you mean with 'database schema is the same for all users...'?
If you want different users to use the *same* procedures, just put the procs in *one* schema. Add the AUTHID CURRENT_USER to them. Now grant the sufficient privileges to execute these procs to your users. That's it.
Oh, and as posted before so many times: please provide infos about your environment (os, rdbms...).
hth,
Guido
Received on Tue Jan 28 2003 - 12:42:24 CET