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
- 8710 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 is a memo field?
Why do we use %rowtype & %type in plsql?
Which normal form is best?
When is the update_statistics command used?
how to use myisamchk to check or repair myisam tables? : Sql dba
What is the unique index?
Write an sql query to select all records from the table?
Can a key be both primary and foreign?
what is dbms? : Sql dba
Why does sql need a server?
How to revise and re-run the last sql command?
Where not exists in sql?
What is pls integer?
What is the use of prepared statement?
Can you skip header records while loading? : aql loader
