Search SSWUG.ORG:

DATABASES

ORA-01031 Creating a View on a Table Accessed via a Role This is an off-site link.  Please review our Terms of Service for additional information.




(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 this article...







comments powered by Disqus