RoleGrabber – Tool DB for Cloud Developers

The following text was translated using a translation program. Please excuse this.

Here I present a small tool database that is intended to support the documentation and development of cloud databases (Starter, Professional, Enterprise).

It contains the following functionalities, some of which can be switched on/off:
- Saving the database schema of the target database consisting of:
Tables
Fields with field type (apart from some layout fields)
Scripts of tables, fields, existing global functions, database triggers
Role assignment in tables fields
Members of the work area with their assigned roles
(The database does not save any other personal data except for the Ninox email address and, if applicable, the user name of the work area members.)

The database offers the following options:
Without password protection of the target database:
Role changes in tables, fields including change documentation
(What was before, what was after the change)
But you should know what you are doing here
Overwriting existing scripts in the target database with saved scripts (script versioning)
Cleans up an incorrect <after opening the database> script that blocks the opening of the database.
Transfers the 'global functions' block and overwrites the block in the target database

Despite password protection of the target database:
Updates changes in the target database and partially documents them
Search options within the saved schema
E.g. Lists all tables/fields that have a specific role
Searches table/field scripts for the use of search terms such as 'select' and lists them.
Searches the script of the 'global functions' block
Prints out role assignments.

After updating the schema:
Marking changes such as:
Users/roles removed from the workspace
Deleted tables/fields
In addition, databases linked through modularization can also be read in.
The special feature here is that you can see the counterpart of the link to the other database/table in the links.
Script links can also be found by searching for 'do as database'.

I created the database for myself in order to examine other databases, especially when there are problems with the functionality due to role assignments and you need to understand it.

To use the database, you need the domain of the target database and the API key of the workspace in which the target DB is located.

After entering both pieces of data, you can use the database by clicking a few buttons and selecting a few things.

Depending on the number of workspace users, tables, fields, and scripts, this can take a few minutes until all the data is written.

Don't lose your nerve and wait until the final message appears.

It is self-explanatory and sometimes displays information when you hover the mouse pointer over elements.

I have tried to ensure that only the information that helps you is displayed.

If no information is displayed, it was not included in the target database when it was retrieved. Therefore, there is always the option of updating to be up to date.

The database is not password protected and is fully accessible in developer mode.
Use of the database is at your own risk.

If you don't click on buttons that cause data changes in the target database, nothing else can happen.

You cannot create or delete users, roles, tables, or fields with this database in the target database.

I hope it supports you in your projects and also helps you find places where you can further improve your database with possible script optimizations.

I hope you enjoy it.

I apologize for the long text, but the functionality is very extensive.