Hope all is well. Here is the dillema I am in ... I have user ID that is creating table ( say ID CREATOR) in 2 schemas ( USER1 , USER2 ). Now USER1 and USER2 are owners of this tables in there schema. What I wanted to do is provide READ only rights to USER1 and USER2 to there own schema!!!
For example, USER1.T1 and USER2.T1 is read only and the owner of this table can't update them !! can this be done ?
Thanks in advance,
Create view for that particular table and this link will help http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_8004.htm#i2065510
Edited by: Sunny kichloo on Apr 25, 2011 12:43 AM