Database permissions requirements
Users who need to compile and install nzLua code must have:
- The permissions to create functions and aggregates.
- Run permissions on the nzLua shared libraries.
- The unfence privilege.
The libnzlua library name is based on the nzLua version. For example, Version
2.0.0 creates the library as libnzlua_2_0_0, version 1.2.5 would create the library
as libnzlua_1_2_5.
/* these permissions are granted by default */
grant execute on libnzlua_2_0_0 to public;
grant execute on libgmp to public;The create_inza_db_developer.sh and create_inza_db_user.sh scripts can be used to grant the necessary permissions for a developer or a user. You can also manually grant these permissions by using the grant command.
A developer would need these
permissions:
grant create function to <user | group>;
grant create aggregate to <user | group>;
grant unfence to <user | group>;
grant execute on function to <user | group>; grant execute on aggregate to <user | group>;grant execute on function to <user | group>;
grant execute on aggregate to <user | group>;It is also possible to grant permissions for a normal user for a specific function or aggregate
using the grant command or by using the Netezza admin tool. When using the grant command in this
manner, it is necessary to specify the function name and
arguments.
grant execute on testfunction(varchar(255),int,int) to <user | group>;