How to hide field preference (Gear icon)?

Question

I have created user with limited access to the DB/ with "Select" permission
https://photos.app.goo.gl/b2uoFBn6D9QCTMby5

But the gear icon (Field preference) still showing up. How do I remove access to them?

Answer 1

The visibility of the gear icon is not related to the table security. A user can have read-only access to a table or database and still be an administrator for that dbFront application.

To create non-admin users you would need to add them as regular users to your application. For more details see: Windows Authentication.

Comments

Thank you for the info