Hi

I have a 11g database, where under one user, which has full privileges, etc, I created a table and stored procedure.

However, the table and store procedure will be accessed and executed by another. Therefore, I used the grant command to this other user permissions to execute the stored procedure and to insert on the table.

The problem being I do not feel that I have set this up correctly because when I log into SQLPLUS as this other user, I can still run the select command, which I felt it would block me in doing.

So, can someone explain to me in simple terms how do I correctly set up a user who can insert only into a table and execute the stored procedure for running the insert command?

Thanks