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.

How to connect a sql*plus session to an oracle server?

0 Answers  

---

How many times can we commit in a loop?

0 Answers  

---

How do I run a sql query in pgadmin 4?

0 Answers  

---

How to call shell script from pl sql procedure?

0 Answers  

---

Is microsoft sql free?

0 Answers  

---

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

What are schema-level triggers?

0 Answers  

---

what is csv? : Sql dba

0 Answers  

---

What are crud methods?

0 Answers  

---

If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,

---

Explain two easy sql optimizations.

0 Answers  

---

State few characteristics of pl/sql?

0 Answers  

---