I 've created a new user called test but I want to see that he has only select privileges on the table.
My problem is since all the users connect thru the front end and to access the tables in a particular schema,
I have cretaed public synonym for all the tables and I've granted select,update,insert,delete to public privileges.
NOw, this user from our other office want to see the data thru oracle so I want to give him access only to view the data.
Even if I give revoke insert,delete,update on table_name from test,
it doesnt work.
Can you please let me know how to handle this? I need to send this userid id as soon as possible.
Thanks a lot