1 Reply Latest reply: Apr 25, 2011 2:43 AM by Sunny kichloo RSS

    Re : Giving read only rights to owner of the table

    591793
      Hello there,

      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,

      Sam