Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

SQLcl clarification for 'project export -schemas x' exporting grants in other schemas

Arvydas KoOct 10 2025 — edited Oct 17 2025

Hello,

I've been searching through the forum, blog posts and documentation, but haven't been able to find an answer to my question.

When executing SQLcl project export using -schemas option and having "schemas" set in project.config.json, what is the reasoning to export grants as grantee within other, non specified schemas?

Following the principle of least privilege when deploying changes for such schema, it is likely that the database user will not have permissions to create these grants in other schemas.

Regards,
Arvydas

This post has been answered by danmcghan-Oracle on Oct 17 2025
Jump to Answer
Comments
Post Details
Added on Oct 10 2025
2 comments
86 views