How can I solve it? Every time I try to grant or to revoke any acess to a table this is what happens inside my APEX application.
Here's the idea of the application
There are many roles in the database, and I want to give them the select privilege using a button which is connected to the fields on the APEX page.
- P3_NEW is the list of values in which contains the roles
- P3_NEW_1 is the list of values in which contains the tables the roles can acess
I made a button and built a dynamic action who has the following code:
BEGIN
EXECUTE IMMEDIATE 'REVOKE SELECT ON ' || :P3_NEW_1 || ' TO ' || :P3_NEW;
END;
and then I get this error:
How can I fix it?
