Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to CREATE VIEW when the privilege is granted through a role.

Nick FuryMar 15 2019 — edited Mar 15 2019

We have a schema where the privileges are granted to a <schema_owner> role and not to the schema itself.

Create table works, but create view fails in sqldeveloper, 18.4 but it works from sqlplus 12.2 and sqlcl 18.4...

The error raised is:

ORA-01031: insufficient privileges

01031. 00000 -  "insufficient privileges"

I can immediately switch to a sqplus window and the command executes successfully.

This post has been answered by Nick Fury on Mar 15 2019
Jump to Answer
Comments
Post Details
Added on Mar 15 2019
9 comments
1,413 views