A user inherently has a profile defined upon the user creation. A user profile determines the compute group users of this profile can run queries in.
To run open analytics tasks, a user or group of users need profiles or explicit privileges that give them access to analytic compute groups. Furthermore, some additional privileges are also needed. See the following statements for examples.
- Grant user or user groups access to analytic or analytic GPU compute groups.
GRANT COMPUTE GROUP analytic_compute_group_name TO username; MODIFY USER username as COMPUTE GROUP = analytic_compute_group_name;
- Grant user or user groups the permission to execute APPLY operator.
GRANT EXECUTE ON FUNCTION TD_SYSFNLIB.APPLY TO username;
- Grant permission to create and manage User Environment using Open Analytics Framework APIs.
GRANT TD_DATA_SCIENTIST to username;