cancel
Showing results for 
Search instead for 
Did you mean: 

SQL table editor - no access to add or delete rows

MarkMatson
New Contributor III

Hi, 

As an admin user I can add and delete rows from a SQL table editor. However a non-admin user does not have access to do so. They can view the data but the add/delete row button on the toolbar are greyed out.

Can someone tell me how to give them access to add/delete rows?

Thank you

Mark

2 REPLIES 2

bilbrandon
New Contributor II

Hi, Mark.

I would start by creating a new security group for this person and assigning that group to the Modify Security role. That's a pretty "powerful" role, however. It may be more access than they need.

Security.png

FrankDK
New Contributor II

I would also check the configuration in the Server Application configuration file, to check how the Database Server configuration is setup:

Screenshot 2022-05-19 080510.png

Cheers Frank