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?