revoke admin argument: Revoke privileges to run SQL administration API commands

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

Syntax

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

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

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

Usage

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

Use the revoke admin argument to revoke the privilege to run SQL administration API commands from individual users. You can revoke the privilege for a specific privilege group or revoke all privileges.

Examples

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

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

The following command revokes all privileges for running any SQL administration commands from the user Bob:

EXECUTE FUNCTION task("revoke admin", "Bob");

Copyright© 2019 HCL Technologies Limited