Skip to Main Content

SQL Developer for VS Code

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!

Missing code in DB SQL

Alan Sawyer44 hours ago

I am working with a DB that has GRANT statements embedded in the SQL script for Tables and Materialized Views. When viewing the SQL with Oracle extensions in Visual Studio Code I do not see the GRANTs in the SQL on the database. But if I look with the SQL Developer tool the GRANTs are in the code. The connections on both tools are using the same UID. Is there a setting or some sort of security role that is needed for these to show in the SQL in Visual Studio Code?

Comments
Post Details
Added 44 hours ago
6 comments
57 views