GRANT INSERT ON TABLE - Oracle 11g
Hi
I have a user in Oracle which I have granted the insert command on a table using GRANT INSERT ON ACCOUNTS TO INSERTUSER;
The grant was successfully granted and there is no problem when inserting data into the table when logging in as that user. My problem is when testing the privilege that it is still possible to run the select command as that user. Therefore, how do I only ensure that this user is only able to insert into this table and not able to select from it? Further, the insert is running under a stored procedure, and I have granted the permission to run execute on that procedure.
Thanks