Home » SQL & PL/SQL » SQL & PL/SQL » SELECT OWN RECORDS INSTEAD OF OWNER's RECORD
SELECT OWN RECORDS INSTEAD OF OWNER's RECORD [message #39569] Tue, 23 July 2002 21:36 Go to next message
emailarif
Messages: 5
Registered: July 2002
Junior Member
Hi Everybody,
I have a peculiar problem.
I hope somebody helps me out.
I have an Owner "O" and a User "U"
The Owner "O" has a procedure which computes
some value and insets it into table "T"

Now this table "T" is with Owner "O" and
also a separate table with same name "T"
with User "U"

The User "U" has been given Execution rights
for this procedure.

Can the "U" SELECT RECORDS from "U" table instead
of "O"s table as well and HOW ?

When User "U" executes it, The table "T"
of Owner "O" gets SELECTED instead of table "T"
of User "U"

How do I get User "U" SELECT table "T" of its own.

Its dead Urgent...
Somebody kindly help me out....

Thanks in advance...
Re: SELECT OWN RECORDS INSTEAD OF OWNER's RECORD [message #39571 is a reply to message #39569] Tue, 23 July 2002 21:51 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Why have you posted this question again? You have already received the answer to your original question. Please do not double-post questions.
Previous Topic: sql query
Next Topic: Date Validation
Goto Forum:
  


Current Time: Thu Mar 28 06:39:19 CDT 2024