# Remote SQL Permissions

**URL:** <https://forum.inductiveautomation.com/t/remote-sql-permissions/1703>\
**Category:** Ignition\
**Created:** [March 30, 2010, 1:30pm UTC](https://forum.inductiveautomation.com/t/remote-sql-permissions/1703 "2010-03-30T13:30:13Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\
**Post date:** [March 30, 2010, 1:30pm UTC](https://forum.inductiveautomation.com/t/remote-sql-permissions/1703/1 "2010-03-30T13:30:13Z")

</div>

What are the minimum permissions that should be given to a remote MYSQL database to allow Ignition to work? I do not want to give more then is needed.

These include:

Select  
Insert  
Update  
Delete  
Create  
Drop  
Grant  
…ETC there are many more.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [March 30, 2010, 9:11pm UTC](https://forum.inductiveautomation.com/t/remote-sql-permissions/1703/2 "2010-03-30T21:11:31Z")

</div>

This is a hard question to answer, because none of these are needed to “allow Ignition to work”, since strictly speaking Ignition doesn’t require a connection to a database.

Now, many of Ignition’s features obviously do require a connection. But what permissions you’ll need depends on what you’re trying to do. If all you need to do is read data, then the SELECT permission is all you’ll need. If you want to user more features like the SQLBridge module and/or an external SQLTags provider you’ll need the ability to do all the CRUD operations (SELECT, INSERT, UPDATE, DELETE, and potentially EXECUTE), as well as table creation (CREATE, ALTER, INDEX)

Hope this helps,

---

<div class="post-metadata">

**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\
**Post date:** [March 31, 2010, 12:17pm UTC](https://forum.inductiveautomation.com/t/remote-sql-permissions/1703/3 "2010-03-31T12:17:25Z")

</div>

Thanks Carl.

Jim