we have a package and we have grants to execute that package inside of that we h

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

Question Posted / sakamuri.srinivas9

3 Answers
7582 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

we have a package and we have grants to execute that package inside of that we have table, here we d..

Answer / prativa mishra

Yes, this package will execute.
example:- suppose we have create a package inside any user
create or replace package sn_pck is
procedure sn_pr(c out number);
end;

create or replace package body scn_pck is
procedure sn_pr(c out number) is
begin
select b into c from sn where name='sony';
DBMS_OUTPUT.PUT_LINE(C);
END;
END;

after that you shd connect hr user
and execute that package it execute 100%

how u will execute on hr user:-

declare
e number;
begin
prativa.sn_pck(e);
end;

note:- here i hv created that package in a user named prativa
and in user i hv create a table sn

Is This Answer Correct ?

2 Yes

1 No

we have a package and we have grants to execute that package inside of that we have table, here we d..

Answer / mathivanan

Of course it wont, it will error out..

As per the question, the user is creating a package inside which he is accessing a table that he has no access to.

it will error out.

Is This Answer Correct ?

0 Yes

0 No

we have a package and we have grants to execute that package inside of that we have table, here we d..

Answer / shareen

select empno,deptno,ename,sal,case when deptno=10 then
sal+3000
when deptno=20 then sal+2000
when deptno=30 then sal+1000
else sal end from emp

Is This Answer Correct ?

1 Yes

2 No

Post New Answer