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