cdr disable grid
The cdr disable grid command removes the authorization to run grid routines from users or servers.
Syntax
Element | Purpose | Restrictions | Syntax |
---|---|---|---|
grid_name | Name of the grid. | Must be the name of an existing grid. | Long Identifiers |
server_group | Name of a database server group in the grid. | Must be the name of an existing database server group in SQLHOSTS. | Long Identifiers |
user_name | Name of the user. | Must be a user with authorization to run grid routines. | Long Identifiers |
The following table describes the cdr disable grid options.
Long Form | Short Form | Meaning |
---|---|---|
--grid= | -g | Specifies the grid for which to revoke privileges. |
--node= | -n | Specifies the servers on which to revoke privileges. |
--user= | -u | Specifies the users to revoke privileges. |
Usage
Use the cdr disable grid command to revoke the permission to run routines on the specified grid from the specified user or server that were granted by the cdr enable grid command.
Return codes
A return code of 0 indicates that the command was successful.
If the command is not successful, one of the following error codes is returned: 5, 220, 222.
For information on these error codes, see Return Codes for the cdr Utility.
Examples
The following example revokes privileges from user bill on the grid1 grid:
cdr disable grid --grid=grid1 --user=bill
The following example shows how to change the authorized server on the grid1 grid from gserv1 to gserv2:
cdr disable grid --grid=grid1 --node=gserv1
cdr enable grid --grid=grid1 --node=gserv2