l***r
发帖数: 459 | 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; <-- error happened here
end;
/ | g**n
发帖数: 431 | 2 You have to get the permission from the owner of that schema. DBA role doesn't
entitle you the privilege to do that.
【在 l***r 的大作中提到】
: 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
| l***r
发帖数: 459 | 3 Why? I even can select from b.first without error.
doesn't
say A
schema, in
that
【在 g**n 的大作中提到】
: You have to get the permission from the owner of that schema. DBA role doesn't
: entitle you the privilege to do that.
| l*********r
发帖数: 80 | 4 are you in oracle?
can you see the details about your permission?
on
【在 l***r 的大作中提到】
: Why? I even can select from b.first without error.
:
: doesn't
: say A
: schema, in
: that
| l***r
发帖数: 459 | 5
Certainly.
It has connect and dba privilege.
schema,
【在 l*********r 的大作中提到】
: are you in oracle?
: can you see the details about your permission?
:
: on
|
|
