I created a new schema in mySQL, then created a new connection in Ignition config. I then created a new User Source in Security/Users, Roles. I selected the Database type security and selected my new schema as the database to use. In the ‘Automatic Mode’ section where it asks for the Tablename prefix, I cleared the box so it would not add a prefix. The User Source was added sudccesfully.
I added one user so it would generate the tables and then went to the new schema in mySQL and looked at the tables. They all had the scada_ prefix even though I cleared that box in the configuration.
I tried this same procedure two more times by deleting the User Source and then dropping all the tables in the schema. Each time it put the scada_ prefix on all the tables again. It appears that it ignores the fact that you don’t want a prefix and puts one anyway.
I decided I would just do it in manual mode, as we are going to make our own user and role administration window. But then I got to thinking about the other tables, i.e. the user_ci and user_ex tables. If they are created manually, with other names for the tables, is this going to break something?