Hi Dan, thank you for this insightful article. I am currently on Oracle 19c, APEX 24.2, and SQLcl 25.3 and wants to start my next project with SQLcl Project. After careful consideration, I have decided that using the admin user is the way to go since my new project will have multiple schemas. One question I have is what privileges should the admin user have? I expect that the admin user will contain the changelog tables and have privileges to create and alter objects in the application schemas.
Steve Max
Hi Dan, thank you for this insightful article. I am currently on Oracle 19c, APEX 24.2, and SQLcl 25.3 and wants to start my next project with SQLcl Project. After careful consideration, I have decided that using the admin user is the way to go since my new project will have multiple schemas. One question I have is what privileges should the admin user have? I expect that the admin user will contain the changelog tables and have privileges to create and alter objects in the application schemas.