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';

UserName

DatabaseName

TableName

ColumnName

AccessRight

A82893

A82893

All

All

CD



Comments