Re: PL/SQL: how to SELECT from other user?
From: R. Scott Hunter <robertscothunter_at_aol.comnospam>
Date: 04 Jan 2001 05:44:34 GMT
Message-ID: <20010104004434.29394.00001466_at_ng-fk1.aol.com>
R. Scott Hunter
Please respond to: rshunter_at_navy.org
GO NAVY!
Received on Thu Jan 04 2001 - 06:44:34 CET
Date: 04 Jan 2001 05:44:34 GMT
Message-ID: <20010104004434.29394.00001466_at_ng-fk1.aol.com>
In the later versions of PL/SQL one can assert a role; prior versions you were stuck with granting those object privileges directly to the executing user or else having the procedure owned by the owner of the objects to be referenced. That's been such a pain in the neck.
R. Scott Hunter
Please respond to: rshunter_at_navy.org
GO NAVY!
Received on Thu Jan 04 2001 - 06:44:34 CET