SET PROPERTY

Description

Sets the user properties, including resources allocated to users.

Syntax

SET PROPERTY [FOR '<username>'] "key" = "value" [, "key" = "value"]

Parameters

• username: the username of the user for whom to set properties.
• Properties in "key" = "value" pairs:
  • max_user_connections: Maximum number of connections.
  • resource.cpu_share: cpu resource assignment.
  • quota.normal: Resource allocation at the normal level.
  • quota.high: Resource allocation at the high level.
  • quota.low: Resource allocation at the low level.

Examples

1. Modify the maximum number of connections to 1000 for the user jack.

   SET PROPERTY FOR 'jack' 'max_user_connections' = '1000';

2. Modify cpu_share to 1000 for the user jack.

   SET PROPERTY FOR 'jack' 'resource.cpu_share' = '1000';

3. Modify the normal-level resource allocation to 400 for the user jack.

   SET PROPERTY FOR 'jack' 'quota.normal' = '400';