Answer Posted / swapna
Definer Rights
--------------
A routine stored in the database by default, is executed
with the definer rights (owner of the routine), depending
on the user who calls it.
For example, table "Test" belongs to schema A. User A
creates a procedure PR_TEST allowing for updates of a
table. User B is granted execute privileges on the
procedure. Now user B cannot access the table as no
privileges have been granted, but can call the procedure to
do the required process logic for updating the table.
Invoker Right
-------------
With Oracle 8i, there is no need for this duplication of
code. A single compiled program unit can be made to use
schema A's objects when invoked by User A and schema B's
objects when invoked by User B.
This way, we have the option of creating a code repository
in one place and sharing it with various production users.
The owner of the routine must grant EXECUTE privilege to
other users.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What do you mean by “trigger” in sql?
What are the features of pl sql?
What packages(if any) has oracle provided for use by developers?
Which is better trigger or stored procedure?
What is normalization? How many normalization forms are there?
Define SQL and state the differences between SQL and other conventional programming Languages?
Can we perform dml in function?
What is procedure explain with program?
What is sequence in sql?
What are the types of dbms?
How can get second highest salary in sql?
Is it possible to sort a column using a column alias?
How do you add a column to a table?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
How does sql store data?
