SQL table editor - no access to add or delete rows

[MarkMatson]

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

[bilbrandon]

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.

[FrankDK]

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

Cheers Frank