求教: dba privilage# Database - 数据库
l*r
1 楼
I have dba priviliege. I am able to create a proceduce in other schema, say A
schema. However, when I try to query a table in other schema, say B schema, in
procedure, I got "table or view doesn't exist". I have to grant select on that
table to A schema and make procedure compiled.
I wonder why?
Thanks.
sample:
create or replace procedure a.proc
(
para_out out varchar
)
as
begin
select notes into para_out from b.first; end;
/
schema. However, when I try to query a table in other schema, say B schema, in
procedure, I got "table or view doesn't exist". I have to grant select on that
table to A schema and make procedure compiled.
I wonder why?
Thanks.
sample:
create or replace procedure a.proc
(
para_out out varchar
)
as
begin
select notes into para_out from b.first; end;
/