Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

who is package executed as

Status
Not open for further replies.
Toe

Toe

Programmer
Oct 26, 2001
71
GB
if i have a pl/sql packege owned by 'user1' is it *always* executed as that user ('user1')?

can it be the case that the packegeis executed as the user who called the package

thanks
 
Sort by date Sort by votes
use

authid current_user

in your procedure. That informs oracle to use the invoking users rights.

Bill
Oracle DBA/Developer
New York State, USA
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
698
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
4K
carp
carp
rk68
  • Locked
  • Question
Display rows as column header
Replies
3
Views
140
Beilstwh
Beilstwh
kernal
  • Locked
  • Question
If there is a Fee on Class Level then that fee overrides Fee on Course Level 1
Replies
3
Views
169
kernal
kernal
Server Guy
  • Locked
  • Question
Solaris 10 update 9 iso file
Replies
0
Views
207
Server Guy
Server Guy

Part and Inventory Search

Sponsor

Back
Top