-
Using dynamic SQL - priv related
Hi
I execute the following
execute immediate 'insert into DVD.TMP_DVD_PRICE select * from ' || l_table;
within a package.
It worked fine in devt (I was connecting as the schema owner) but in UAT it is failing on connect with a different account.
The new account has permissions on the package the command is in. Do I need to grant insert rights to this account also? Or is there any other reason that it might be failing?
many thanks
Kerrie
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|