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