I can SELECT from SQL*Plus but not from PL/SQL. What is wrong?
PL/SQL respect object privileges given directly to the user, but does not observe privileges given through roles. The consequence is that a SQL statement can work in SQL*Plus, but will give an error in PL/SQL. Choose one of the following solutions: • Grant direct access on the tables to your user. Do not use roles!
Related Questions
- I know that I have several user profiles configured in Netscape, but Im not being given the option to select a profile when I launch Netscape. Whats wrong?
- I have select the wrong product name/grammage/size/brand/quantity in my order form. How can I change/edit/delete the order?
- I can SELECT from SQL*Plus but not from PL/SQL. What is wrong?
