smena
asked on
EXECUTE IMMEDIATE - ORA-01031: insufficient privileges
I'm GETTING ORA-01031 ON EXECUTE IMMEDIATe while executing proc.
I have a privelge to create table, which privileges need to be granted to my account to execute this command successfully?
I have a privelge to create table, which privileges need to be granted to my account to execute this command successfully?
This might give you some clue: http://asktom.oracle.com/~tkyte/Misc/RolesAndProcedures.html.
Longer discussion is here:
http://216.239.39.104/search?q=cache:y3910TNO61UJ:asktom.oracle.com/pls/ask/f%3Fp%3D4950:8:1320218815388063256::NO::LAST_PAGE:8:YES+ORA-01031+ON+EXECUTE+IMMEDIATe+while+executing+proc&hl=en
ASKER
... CREATING TABLE
EXECUTE IMMEDIATE ('CREATE TABLE TEST (COL CHAR(5)')
EXECUTE IMMEDIATE ('CREATE TABLE TEST (COL CHAR(5)')
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your responses, though I still need to use EXECUTE IMMEDIATE ('CREATE TABLE')
EXECUTE IMMEDIATE (what?)
Can you paste your script please.