SELECT OWN RECORDS INSTEAD OF OWNER's RECORD [message #39569] |
Tue, 23 July 2002 21:36 |
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...
|
|
|
|