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 ?