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: 184
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

Report message to a moderator

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: 20097
Registered: January 2009
Senior Member
GRANT CREATE TYPE TO USERA;

Report message to a moderator

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: 54167
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue May 21 21:48:38 CDT 2013

Total time taken to generate the page: 0.09660 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.