- What database engine?
- Are you accessing using an Ignition gateway database connection? (Gateway → Config → DATABASES → Connections.)
- If so, what is the status of the gateway connection?
- Where are you receiving the error? Can you post the full contents?
The normal setup is that Ignition has the required database credentials and Ignition controls which users have access - not the database doing the controlling.
See User Source Automatic not creating table in MySQL DB - #12 by jspecht where the problem was due to using double-quotes for the column names.