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 do I clear the screen in sql plus?

0 Answers  

---

What are stored procedures used for?

0 Answers  

---

How do I pipe the output of one isql to another?

0 Answers  

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

0 Answers  

---

What is difference between primary and secondary key?

0 Answers  

---

---

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers   TCS,

---

What are the benefits of pl/sql packages?

0 Answers  

---

Explain the advantages and disadvantages of stored procedure?

0 Answers  

---

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

Is sql similar to python?

0 Answers  

---

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent

3 Answers  

---

SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows

3 Answers  

---