3507788 - Not possible to create a schema with a database analysis user

A SAP Datasphere space-level or tenant-level database analysis user cannot create a new schema in SAP Database Explorer, the statement is failed with the following error:

Could not execute 'CREATE SCHEMA ABC#XYZ'
Error: (dberror) [258]: insufficient privilege: Detailed info for this error can be found with guid '

SAP Datasphere

1. Create a Space-level or a Tenant-level database user - SAP Help Portal Documentation: Database Users 
2. Logon to SAP Database Explorer
3. Execute a CREATE statement like CREATE SCHEMA ABC#XYZ

A Database User on Space-Level/Tenant-Level is not allowed to create schemas.

In order to create a schema, please use Database User Group, more information in SAP Help Portal Documentation: Creating a Database User Group.

By default, no SAP Datasphere space can access the database user group schema. To grant a space read privileges from the database user group schema, use the GRANT_PRIVILEGE_TO_SPACE stored procedure - SAP Help Portal Documentation: Allow a Space to Read From the Database User Group Schema.

SAP Help Portal Documentation: 

• Database Users
• Creating a Database User Group
• Allow a Space to Read From the Database User Group Schema

script, create schema, privileges, GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS, 258  , KBA , DS-SM , Space Management , How To