1. Revoke all the permissions given to the user for the required table
2. Create a Role
3. Grant the necessary permissions for that table to the Role
4. On the new-form instance trigger of the form set the role using the dbms_session packaged procedure
5. Once the session gets over the role also...
This is not like MS SQL Server where the scope of the temporary table gets over once the stored procedure is executed. In Oracle the temporary table you create will become a permanent one and it has to be explicitly handled. Again you have to make sure whether this SP will be run concurrently...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.