Title: RE: Creating a simple stored procedure
Have the owner of MyTab grant to appropriate privileges directly, it seems you have them through a role. Also check for a synonym for MyTable as well.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc
Bob,
where does the table mytab exist? - probably not in the same account as
where you are creating the sp. in this case, you need to do two things.
change the sp to say:
update {schema}.mytab where {schema} is where the table exists.
secondly, from {schema} you need to : grant select,
Title: RE: Creating a simple stored procedure
Hi Bob,
first of all who are you creating the sp as?
If it's not the table owner, is there a synonym declared? Is update granted via a role? If it is, grant update directly to the procedure owner.
Or forget all this and run the proc
Bob,
where does the table mytab exist? - probably not in the same
account as where you are creating the sp. in this case, you
need to do two things. change the sp to say:
update {schema}.mytab where {schema} is where the table exists.
secondly, from {schema} you need to : grant
Bob,
Make a sure you have access to update 'mytab'.
Rgrds,
Sony
-Original Message-
From: Bob Metelsky [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 10:31 PM
To: Multiple recipients of list ORACLE-L
Subject: Creating a simple stored procedure
How can I create