3524 The User does not have CREATE DATABASE access to database XXXXXX

Problem:

Reason:

The user does not have create database privilege.

Solution:

Grant create database privilege to the user.

Check the user have create database(CD) privilege or not

SELECT username,databasename,tablename,columnname,accessright

FROM dbc.allrightsV

WHERE username = 'A82893'

and accessright='CD';

return no rows

Grant the Create Database privilege from parent or the user who have grant option

grant CD on A82893 to A82893;

Now you can see the user have Create Database (CD) privilege

SELECT username,databasename,tablename,columnname,accessright

FROM dbc.allrightsV

WHERE username = 'A82893'

and accessright='CD';