Re: Another user populates my local tables using a "procedure" under my account.

From: L120bj <l120bj_at_aol.com>
Date: 1997/03/11
Message-ID: <19970311184101.NAA07023_at_ladder01.news.aol.com>#1/1

Unfortunately not. Stored procedures execute with the privileges of the user which owns them, therefore they will write to tables in that user's schema if they exist.

---

---

Subject: Another user populates my local tables using a "procedure" under my account.
From: "Gina M. Oliver" <Gina-Oliver_at_worldnet.att.net> Date: Sun, 09 Mar 1997 16:46:13 -0600
Message-ID: <33233DB5.1504_at_worldnet.att.net>

I've developed a procedure under my local Oracle user account which performs certain calculations and sets a few local variables. Also it populates/updates some small local temporary tables with the data queried from a main database. I've given another user the "execute" privilege on this procedure and she has identical local temporary tables as of mine.

When she runs this procedure the plain calculation part works fine and her local variables are set correctly. But, the problem is: my local tables get popualted/updated instead of her own! even though she has no granted privileges
on my local tables.

Is there a way this could be avoided so she can run the program without effecting the tables in my user account. Thanks for any hint. Received on Tue Mar 11 1997 - 00:00:00 CET