# User permissions for postgresql?

**URL:** <https://forum.xojo.com/t/user-permissions-for-postgresql/56039>\
**Category:** Databases\
**Created:** [August 18, 2020, 9:39pm UTC](https://forum.xojo.com/t/user-permissions-for-postgresql/56039 "2020-08-18T21:39:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![MarkusR](https://forum.xojo.com/user_avatar/forum.xojo.com/markusr/32/685_2.png) [@MarkusR](https://forum.xojo.com/u/MarkusR)\
**Post date:** [August 18, 2020, 9:39pm UTC](https://forum.xojo.com/t/user-permissions-for-postgresql/56039/1 "2020-08-18T21:39:53Z")

</div>

hello,  
which permissions do i need to set if a user need read & write the table data from within my xojo (web) app?

missing something like read/write data and delete row checkbox.

 ![Snap_2020.08.18_23h31m46s_001_](https://forum.xojo.com/uploads/default/original/2X/3/376bbc2e12dbbc2c4ec965d12abb14461ea98b4f.png)

---

<div class="post-metadata">

**Author:** ![Norman\_Palardy](https://forum.xojo.com/user_avatar/forum.xojo.com/norman_palardy/32/169_2.png) [@Norman\_Palardy](https://forum.xojo.com/u/Norman_Palardy)\
**Post date:** [August 18, 2020, 9:45pm UTC](https://forum.xojo.com/t/user-permissions-for-postgresql/56039/2 "2020-08-18T21:45:09Z")

</div>

usually you grant read update and delete permissions to a specific user

---

<div class="post-metadata">

**Author:** ![MarkusR](https://forum.xojo.com/user_avatar/forum.xojo.com/markusr/32/685_2.png) [@MarkusR](https://forum.xojo.com/u/MarkusR)\
**Post date:** [August 18, 2020, 9:47pm UTC](https://forum.xojo.com/t/user-permissions-for-postgresql/56039/3 "2020-08-18T21:47:53Z")

</div>

its not there  
only:  
can login  
superuser  
create roles  
create database  
change schema  
inherit from parents  
can make backups

---

<div class="post-metadata">

**Author:** ![Norman\_Palardy](https://forum.xojo.com/user_avatar/forum.xojo.com/norman_palardy/32/169_2.png) [@Norman\_Palardy](https://forum.xojo.com/u/Norman_Palardy)\
**Post date:** [August 18, 2020, 9:49pm UTC](https://forum.xojo.com/t/user-permissions-for-postgresql/56039/4 "2020-08-18T21:49:57Z")

</div>

have you added users ?  
what if you select one of those users ?  
or select one of the tables and not the entire schema ?

I know PG can do this

---

<div class="post-metadata">

**Author:** ![MarkusR](https://forum.xojo.com/user_avatar/forum.xojo.com/markusr/32/685_2.png) [@MarkusR](https://forum.xojo.com/u/MarkusR)\
**Post date:** [August 18, 2020, 10:00pm UTC](https://forum.xojo.com/t/user-permissions-for-postgresql/56039/5 "2020-08-18T22:00:16Z")

</div>

ahh found something 🙂  
and **sequences** need also permissions for new auto id.

 ![Snap_2020.08.18_23h57m52s_001_](https://forum.xojo.com/uploads/default/original/2X/1/18b8959abd638bccf38a63c6e36e7cfc882ddda4.png)

---

<div class="post-metadata">

**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\
**Post date:** [April 29, 2021, 4:36pm UTC](https://forum.xojo.com/t/user-permissions-for-postgresql/56039/6 "2021-04-29T16:36:57Z")

</div>