# Exploring database things
Creating roles
adding users to the roles
Giving privileges
Cloud database throwing me an error when the "create user" command is run
MySQL said:
#1227 - Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
here, iam the system administrator in my appian site.
Discussion posts and replies are publicly visible
No. Security in Appian does not work on the database level. Is this what you try to do?
docs.appian.com/.../User_Roles.html
I have gone through the document you sent, but I didn't get a clear idea.
If you don't mind please list out the steps to achieve this.
Thanks in advance.
Please explain what you want to achieve.
I just want to create one user in the database and also give some privileges to the role to which it was added.
What user you are trying to Add? Appian user? If Yes, then why not you are using the Appian environment to do this?
Again. Security in Appian is NOT based on DB users.
Now, what is your higher level goal? Please elaborate and we try to support you in your design.
Cloud database restricting me from performing DCL commands
It seems that there exists a solution in the document you sent, but I am unable to extract the answer from it. could you please help me?
That does not help us to understand your use case. What do you want to achieve managing users in the DB?