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
EXECUTE FUNCTION
{
admin
| task
}
(
"revoke admin"
,"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");