New system table EXA_SYS_SCRIPTS lists pre-installed system scripts
Details
| Detail name | Value |
|---|---|
| Changelog Number | 10399 |
| Type | New Feature |
| Status | Resolved |
| Fix Versions | Exasol 7.0.0 |
| Resolution Date | 2020-09-11 |
Description
New system table EXA_SYS_SCRIPTS which lists the system scripts.
System scripts are scripts that are pre-installed in Exasol and can be used for a wide-range of purposes. An example system script is GRANT_USAGE_PRIVS which grants USAGE privileges on schemas to user/roles that have object privileges on the schemas or the objects within them.
System scripts cannot be altered by users. System scripts are visible and executable by all users, but the actions within the script may require certain privileges.
