While creating a workspace using a new user schema, it is creating two user accounts in the database. For instance, if I specify DEMO as the new schema name in the Create Workspace page, it is creating DEMO user and also WKSP_DEMO user. The WKSP_DEMO user has all the necessary privileges granted automatically but the DEMO user is just vanilla with no privileges.
Wondering what the purpose of the DEMO user is with no privileges which is what I intended to create. WKSP_DEMO is too cumbersome to type in SQL scripts. Anyway to grant privileges similarly to DEMO user and blow off WKSP_DEMO user? (I know how to assign schema to the workspace from the Apex Instance Admin).
On Oracle Cloud.
TIA