Re: Urgent Help !!!

I believe 7.3.4.X on up provides this capability. User u1 will need to grant update access on u1.table to u2. u2 will then need to grant execute permission on u2.procedure to u1.

If I remember correctly, the permissions will take on those of the procedure being executed (i.e. the owner who create the procedure) so the user who owns the proc will need update permissions, while at the same time, the other user will need permission to execute this.

And, if this is to be run as part of a dbms_job, remember when the job runs, regardless of who owns the job, role permissions will not be applicable, only those explicitely assigned to the calling user itself. (I am not sure if this is still the case in O8.X, but I know it's true in 7.3.4.1)

In article <82f622$jbp$1_at_perki.connect.com.au>,   "Tom Zamani" <tomz_at_redflex.com.au> wrote:
> Could some one help me with this please.
> I need to set up some users which they need to executed procedures
which are
> owned by other users, these procedures then update certain tables,
these
> tables are identical except the data.
> My question is how can I set up the database so eg
> user u1 executes a procedure which is owned by user u2, and that
procedure
> updates the table owned by u1.
>
> As I have been told oracle 8i provide such facility, do you know
anything
> about this.
> Thanks a lot Tom
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 06 1999 - 20:36:16 CET