gilgantic wrote:
> I am an Oracle 8i and 9i novice. Help me understand the GRANT command?
>
> Currently, I am running stored procedure called, "sample".
>
> CREATE OR REPLACE PROCEDURE sample(schema_name IN VARCHAR2)
> *
> ERROR at line 1:
> ORA-01031: insufficient privilege
>
> To remedy this I was told to GRANT privilege to the user, because the user did
> not have CREATE or REPLACE privileges. How can I do this?
>
> Thanks!
> Gil
connect as system, and issue the following command:
SQL> grant connect, resource to [the user that failed to create a
procedure];
Then connect as the user, and retry
--
Regards, Frank van Bortel
Received on Thu Apr 24 2003 - 13:38:41 CDT
