on 12-28-2023 1:30 PM
Hello experts,
I try to call a PAL procedure from a Datasphere SQL View (type table function).
The SQL View compile correctly.
But the database user associated with the space ("SPACE_XX") doesn't have the right permission.
I have created a database user inside the space ("SPACE_XX#DB_USER") and from the database explorer the function works.
The problem seems that the database user associated with the space doesn't have the AFLPAL role associated with it.
Could this be an improvement request, to grant this role ($$global$$.scriptServerAccess to the database user associated with the space?
Best Regards,
Alberto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Andreas,
Yes the database user (SPACE_XX#DB_USER) has APL/PAL activated.
And from database explorer the function calls work.
This flag grant a role to the database user created under space management.
But to use those libraries inside datasphere sql views (inside the modeling web pages of datasphere), we need this role to be assigned to the database user of the space itself ( SPACE_XX).
Edit:
the role $$global$$:ScriptServerAccess is managed by Datasphere application, user DWC_TENANT_OWNER, so there is no way to assign the correct role to the user used by the space itself.
Best regards,
Alberto
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.