Re: GRANT Command?
From: Frank <fvanbortel_at_netscape.net>
Date: Thu, 24 Apr 2003 20:38:41 +0200
Message-ID: <3EA82F31.7020102_at_netscape.net>
Date: Thu, 24 Apr 2003 20:38:41 +0200
Message-ID: <3EA82F31.7020102_at_netscape.net>
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 BortelReceived on Thu Apr 24 2003 - 20:38:41 CEST