Home » SQL & PL/SQL » SQL & PL/SQL » TYPE NUM_ARRAY as table of number (Lunix 5 Oracle 11.2.0.2)
TYPE NUM_ARRAY as table of number [message #572049] Wed, 05 December 2012 10:11 Go to next message
BeefStu
Messages: 192
Registered: October 2011
Senior Member
Can anybody tell me exactly what permissions I need to exectute the following
SQL statement.


SQL> CREATE OR REPLACE TYPE NUM_ARRAY as table of number;
  2  /
CREATE OR REPLACE TYPE NUM_ARRAY as table of number;
*
ERROR at line 1:
ORA-01031: insufficient privileges



When I grant DBA to the ID which runs the SQL it works fine.

Thanks in advance to all who answer
Re: TYPE NUM_ARRAY as table of number [message #572050 is a reply to message #572049] Wed, 05 December 2012 10:26 Go to previous messageGo to next message
BlackSwan
Messages: 22781
Registered: January 2009
Senior Member
GRANT CREATE TYPE TO USERA;
Re: TYPE NUM_ARRAY as table of number [message #572051 is a reply to message #572049] Wed, 05 December 2012 10:29 Go to previous message
Michel Cadot
Messages: 59085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once more PLEASE read Database SQL Reference BEFORE using ANY SQL feature.
A forum is NOT a substitute for the documentation.
You are wasting everyone time and above all you steal the time we can help those who have a REAL problem.

Regards
Michel
Previous Topic: Associative Array help - no data found
Next Topic: Create View from Dynamic Query (or Function Returning Query)
Goto Forum:
  


Current Time: Tue Sep 16 11:02:06 CDT 2014

Total time taken to generate the page: 0.08294 seconds