Skip to main content
mohank0008
Known Participant
Sep 6, 2022 7:37 AM UTC
Question

Regarding the user roles and security in cloud database

# 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.
Do I need to configure anything before I go?

12 replies

stefanhelzle0001
Brainy
Sep 6, 2022 11:21 AM UTC

No. Security in Appian does not work on the database level. Is this what you try to do?

harshitb6843
Brainy
Sep 6, 2022 11:29 AM UTC
mohank0008
Known Participant
Sep 6, 2022 12:49 PM UTC

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.

stefanhelzle0001
Brainy
Sep 6, 2022 12:54 PM UTC

Please explain what you want to achieve.