This discussion is archived
1 Reply Latest reply: Apr 25, 2011 12:43 AM by Sunny kichloo RSS

Re : Giving read only rights to owner of the table

591793 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points