SQL Historian minimum database permissions

Ignition
1

When creating an SQL user for SQL Historian, what basic permissions are required?

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • CREATE
  • DROP

I assume that, at minimum, we need these in order to add tags and inject our data:

  • CREATE
  • INSERT
  • SELECT

And if Ignition manages partitioning, I assume we also need to be able to purge unused tags and drop partitions:

  • DROP
  • DELETE

UPDATE doesn't seem applicable, as I'm not aware that Ignition modifies any written data?

Thanks!

2

Metadata.

3

Yeah, Ignition needs basically full permissions to do all the things it does with the SQL database.
Rows in sqlth_partitions, sqlth_te and probably other tables I'm forgetting about will need to be updated over time. If it's a concern, create a dedicated schema/"database" and a specific Ignition user in your DB that only has access there.