wass wrong in it??
Originally posted by nour
I agree with you OracleDoc but try to create a view(v2)in U2 schema using a U1 tab (U2 view : select * from u1.t1).
U2 can do : select * from u1.t1
U2 CANNOT do : select * from u2.v2 (you need an explicit privilege on u1.t1 ...).
Try this and let me know if I am wrong ?
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"