# Use Noco with a read-only mysql user \[May 30\]

**URL:** <https://community.nocodb.com/t/use-noco-with-a-read-only-mysql-user-may-30/502>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 9:55am UTC](https://community.nocodb.com/t/use-noco-with-a-read-only-mysql-user-may-30/502 "2022-11-03T09:55:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:55am UTC](https://community.nocodb.com/t/use-noco-with-a-read-only-mysql-user-may-30/502/1 "2022-11-03T09:55:45Z")

</div>

> 🙋‍♂️ **cristian76** _asked_

## Im a new in nocodb, its possible to use nocodb with a ready-only mysql user ? Will be possible to create field in nocodb interface ?

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:55am UTC](https://community.nocodb.com/t/use-noco-with-a-read-only-mysql-user-may-30/502/2 "2022-11-03T09:55:47Z")

</div>

> 🙋‍♂️ **FrancyMak** _replied_

#### Hello! Obviously with a read-only user you cannot create fields on the db, because Noco must have the ability to write and eventually modify the database.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:55am UTC](https://community.nocodb.com/t/use-noco-with-a-read-only-mysql-user-may-30/502/3 "2022-11-03T09:55:48Z")

</div>

> 🙋‍♂️ **FrancyMak** _replied_

#### However, if you need a user to only be able to read and not edit/create, you can create a user with the viewer role.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:55am UTC](https://community.nocodb.com/t/use-noco-with-a-read-only-mysql-user-may-30/502/4 "2022-11-03T09:55:49Z")

</div>

> 🙋‍♂️ **cristian76** _replied_

#### Yes i understand, but will be great feature if Nocodb can work with a readonly user from database and allow to create custom new fields without sending to the Database, keeps the original database untoched.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:55am UTC](https://community.nocodb.com/t/use-noco-with-a-read-only-mysql-user-may-30/502/5 "2022-11-03T09:55:50Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/980255328472023050)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)