The system administrator or DBA needs to grant users the necessary permissions and privileges to use the APPLY table operator.
To use the APPLY table operator, you need to provide the following permissions:
- Grant user the permission to run the APPLY table operator.
GRANT EXECUTE ON FUNCTION TD_SYSFNLIB.APPLY TO username; - Grant user the permission to interact with the user environments APIs. This allows the user to create, update, and remove scoped user environments.
GRANT TD_DATA_SCIENTIST to username;