GRANT Command?
From: gilgantic <gilgantic_at_yahoo.com>
Date: 24 Apr 2003 11:04:58 -0700
Message-ID: <d6052717.0304241004.eaf08e7_at_posting.google.com>
Date: 24 Apr 2003 11:04:58 -0700
Message-ID: <d6052717.0304241004.eaf08e7_at_posting.google.com>
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
Received on Thu Apr 24 2003 - 20:04:58 CEST