ORA-01031 Creating a View on a Table Accessed via a Role

(Andrew Reid) This example shows that you cannot create a view on a table which you access via a role. It was tested on Oracle 11. First I created a role:

Read More - Register for Free Membership