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
- 7607 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 an intersect?
How many types of relationship are there?
How to get list of all tables from a database?
What are procedures used for?
what are the types of subquery? : Sql dba
How long does it take to learn pl sql?
Can we rename a column in the output of sql query?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is the purpose of the primary key?
What is input buffer in sql*plus?
What is graph sql?
What is minus?
What is exit statement?
How do I pipe the output of one isql to another?
How many types of tables are there?
