Execute Immediate within a stored procedure keeps giving insufficient priviliges error

by

Oracle’s security model is such that when executing dynamic SQL using Execute Immediate (inside the context of a PL/SQL block or procedure), the user does not have privileges to objects or commands that are granted via role membership. Your user likely has “DBA” role or something similar. You must explicitly grant “drop table” permissions to this user. The same would apply if you were trying to select from tables in another schema (such as sys or system) – you would need to grant explicit SELECT privileges on that table to this user.

More Related Contents:

  1. Merging two tables in SQL [closed]
  2. How to SELECT FROM stored procedure
  3. Function vs. Stored Procedure in SQL Server
  4. Passing an array of parameters to a stored procedure
  5. Pivoting rows into columns dynamically in Oracle
  6. The maximum recursion 100 has been exhausted before statement completion
  7. How to assign an exec result to a sql variable?
  8. SQL Server SELECT into existing table
  9. How to check if a stored procedure exists before creating it
  10. Concatenate results from a SQL query in Oracle
  11. How to kill a running SELECT statement
  12. SQL Server silently truncates varchar’s in stored procedures
  13. Split values over multiple rows [duplicate]
  14. Selecting the second row of a table using rownum
  15. Return setof record (virtual table) from function
  16. Must declare the scalar variable
  17. How to count the number of occurrences of a character in an Oracle varchar value?
  18. Ad hoc queries vs stored procedures vs Dynamic SQL [closed]
  19. How can I generate a temporary table filled with dates in SQL Server 2000?
  20. Stored procedure that exports data into csv files only exports to one file
  21. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  22. Insert Update stored proc on SQL Server
  23. SQL Server: should I use information_schema tables over sys tables?
  24. SQL CREATE LOGON – can’t use @parameter as username
  25. PostgreSQL: Give all permissions to a user on a PostgreSQL database
  26. What is the difference between a stored procedure and a view?
  27. Functions vs Stored Procedures
  28. Oracle Date TO_CHAR(‘Month DD, YYYY’) has extra spaces in it
  29. Call stored procedure with table-valued parameter from java
  30. Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?

Leave a Comment