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
- 8118 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
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is difference sql and mysql?
What is the difference between a query and a report?
What does subquery mean in sql?
How many parts of a pl sql block are optional?
How do I filter in sql profiler?
How many clustered indexes can be created on a table?
explain normalization concept? : Sql dba
what is a trigger in mysql? Define different types of trigger. : Sql dba
Is t sql a programming language?
How do you write an inner join query?
how is myisam table stored? : Sql dba
How can you save or place your msg in a table?
what is a field in a database ? : Sql dba
What operating systems are supported by oracle sql developer?
