Many developers end up with
rootas the user for their application database - sometimes even in production. This is because writing permissions is often difficult or cumbersome. Arctype simplifies this process, providing you with an easy way to create new database users, edit existing users, and set permissions.
To access this feature, click the 3 dots next to
Search Tablesand select
This will take you to a new tab called "Manage users." From here, you can scope permissions by SQL command, table, and schema for existing users, or choose Add new user role and provision permissions to create a new user.
The SQL required to manage these permissions is automatically generated for you when you make your selections. Review it, then choose Accept to apply the changes. You can also delete users by choosing the
Xnext to their name.
Deleting a user cannot be undone. Be careful when using this feature!