Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 8834 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the built in functions of sql?
What is data types in sql?
What is difference between primary and secondary key?
How to load data with sql*loader?
Is sql the best database?
how can we submit a form without a submit button? : Sql dba
What is character functions?
What is sql catalog?
What packages are available to pl/sql developers?
How does left join work in sql?
what is normalization? : Sql dba
What is sqlite format?
what are different types of collation sensitivity? : Sql dba
describe transaction-safe table types in mysql : sql dba
Is it important to partition hard disk?
