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