I have a Ignition Test VM connecting to an Oracle Express Install in same VM. I could get Historian to log data using the “system” user. I created a new user “ignition” using Oracle SQL Developer(kinda like MS SQL Management Studio). I tried to give the new “ignition” user as many privileges as possible. But it only made a few tables, it did not make the SQLT_Data tables. Easy Historical chart did not work with “ignition” user in Database connection.
I could go back and modify the Database connection and use the “system” user again and I could get it to start logging Historical data again.
Does Ignition know if it Made the SQLT_Data tables under one user and won’t try to create them again, even though I am using a different Oracle user name? Or maybe I don’t have the permissions correct on my “ignition” user?
As for Oracle XE Database structure, what I could glean off the internet. You can’t make a new “clean/ empty” database you only get XE. But you can make a new user, then you when connect as your new user you only have access to that user’s tables and you wont see all the System user’s tables. Correct me if I am thinking about this wrong. I am MS SQL where you can create a new