Interested to Buy Any Domain ? << Click Here >> for more details...
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 is sp_pkeys? : Transact sql
what is cross join? : Sql dba
What is sql procedures and functions?
Can a composite key be null?
what is try_catch block in procedure
What are sql*plus environment variables?
What is sql data?
Does truncate free space?
What are conditional predicates?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Can we group by two columns in sql?
what are the t string functions available in tsql? : Transact sql
What is out parameter used for eventhough return statement can also be used in pl/sql?
What is the difference between sum and count in sql?
What schema means?
