When I created the user it only had insert on to that table and execute on the stored procedure. I never granted select on the table where I only wanted that user to have insert on it.
When you create a user through Oracle Enterprise Manager does it set any defaults? Because this is how I created the user.




Reply With Quote