New function SCOPE_USER for views and virtual tables
Details
| Detail name | Value |
|---|---|
| Changelog Number | 5999 |
| Type | New Feature |
| Status | Resolved |
| Fix Versions | Exasol 6.1.0 |
| Resolution Date | 2018-05-09 |
The new built-in function SCOPE_USER returns the owner of the innermost view or virtual table it is called in. Outside of views and virtual tables the function returns the current user like the existing function CURRENT_USER.
Example Usage
CREATE VIEW example AS SELECT SCOPE_USER;
The following query always returns the owner of the view, independent of the current user:
SELECT * FROM example;
Changed behavior
New reserved keyword SCOPE_USER.
