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?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
How do you write a complex sql query?
Where the integrity constrints are stored in Data Dictionary?
what are all different types of collation sensitivity? : Sql dba
Which is better varchar or nvarchar?
How does join work in sql?
What are different methods to trace the pl/sql code?
what is myisam? : Sql dba
What is sql used for?
How do you run a query?
What are all the difference between Like and Contains ?
I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
full outer join syntax