grant admin argument: Grant privileges to run SQL administration API commands

Use the grant admin argument with the admin() or task() function to grant privileges to run SQL administration API commands.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+--(--"--grant admin--"------------>
                     '-task--'                         

>--,--"--user_name--"--,--"--privilege_group--"--)--;----------><

Element Description Key Considerations
user_name The name of the user for which privileges are granted.  
privilege_group The name of the privilege group. See SQL administration API portal: Arguments by privilege groups for a list of privilege groups.

Usage

Individual users can be granted privileges to administer their database servers by running SQL administration API commands. Users with these privileges can connect to a database server with their user name and run SQL administration API commands, by connecting directly.

Only user informix, or a user with ADMIN or GRANT privilege for SQL administration API commands, can use the grant admin argument.

Example

The following command grants the privilege for running backup and restore SQL administration commands to the user Bob:

EXECUTE FUNCTION task("grant admin", "Bob", "BAR");

Copyright© 2019 HCL Technologies Limited