If you are only performing actions of reading from and writing to the ontology, you will need these permissions:
- SQL Server: db_datawriter, db_datareader.
- MySQL: SELECT, INSERT, UPDATE, DELETE, EXECUTE, SHOW VIEW, LOCK TABLES
If you need to performed advanced actions like database migration, you also require:
- SQL Server: db_owner
- MySQL: ALTER, INDEX, CREATE VIEW, DROP, TRIGGERS.