Nov 9, 2007

ORA-1031

This error is caused for numerous permission reasons.
Below is an explanation of some of these problems and are they can be resolved.

  1. Selecting a view when underlying tables are owned by an alternative schema.
The problem is the underlying tables havn't been given the correct privs to the user that owns the view. The grants for these underlying tables need to be given to owner of the view with the grant option.

ie: GRANT SELECT ON "underlying table" TO "view owner" WITH GRANT OPTION