avatar
求教: 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;
/
avatar
g*n
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

avatar
l*r
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.

avatar
l*r
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

avatar
l*r
5

Certainly.
It has connect and dba privilege.
schema,

【在 l*********r 的大作中提到】
: are you in oracle?
: can you see the details about your permission?
:
: on

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。