Re: a question for stored procedure
From: Tony Damon <bfntd_at_aimnet.com>
Date: 1996/02/23
Message-ID: <4gle9u$d4l_at_news2.aimnet.com>#1/1
Date: 1996/02/23
Message-ID: <4gle9u$d4l_at_news2.aimnet.com>#1/1
Scott Urman (surman_at_oracle.com) wrote:
: |>
: You have been granted SELECT on DBA_OBJECTS via a role (the DBA role, no
: doubt). All roles are disabled in stored procedures. You need to connect as
: SYS, and GRANT SELECT ON dba_objects directly to yourself.
:
This is not my understanding. I'm under the impression that you operate under the authority of whoever *created* the stored procedure. That is, user A does not need access to table EMP if the user that created the stored procedure has access to it.
However, if you use dynamic sql, then the userid that is executing the statement in that procedure must have the correct authority.
Tony Damon Received on Fri Feb 23 1996 - 00:00:00 CET