what is definer rights invoke rights?



what is definer rights invoke rights?..

Answer / 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

More SQL PLSQL Interview Questions

differentiate between float and double. : Sql dba

0 Answers  


What are the types of functions in sql?

0 Answers  


Does truncate release storage space?

0 Answers  


What are the packages in pl sql?

0 Answers  


How does postgresql compare to mysql?

0 Answers  






Do we need to create index on primary key?

0 Answers  


Difference between a query and strored procedure?

4 Answers   Microsoft,


What is a trigger in pl/sql?

1 Answers  


How can we overcome recursive triggers in SQL?

1 Answers   iFlex,


Can you selectively load only those records that you need? : aql loader

0 Answers  


What is the difference between truncate and drop statements?

0 Answers  


explain what is mysql? : Sql dba

0 Answers  


Categories