I think that there are two reasons to do it:
1) You need permissions that are granted to another user
2) You need to work in another schema and you have permissions to these
objects.
In 1) you can grant yourself the necessary permissions.
in 2) try execute immediate 'alter session set current
My guess is that 'connect' is a sql*plus command (rather than a pl/sql command) so
wouldn't work with execute immediate.
But maybe you could break out the portions of your code that need to run as a
different user into a separate package, owned by that user?
HTH,
-Roy
Roy Pardee
the user would be sys. I need to create grants to DBA_ views on the fly so we can
scale an application. We add new users and some of them need access to these to run a
load process properly.
ill just run it from unix.
From: Pardee, Roy E [EMAIL PROTECTED]
Date: 2003/08/20 Wed PM 01:24:25
