Question & Answer
Question
What happens when a user is a member of groups with different resource limits?
Answer
This situation is not possible because a user can be a member of only one resource group. The following output shows that the user account, akaul, is a member of three user access groups but only one resource group:
SYSTEM(ADMIN)=> \du akaul
List of Users
USERNAME | VALIDUNTIL | ROWLIMIT | SESSIONTIMEOUT | QUERYTIMEOUT | DEF_PRIORITY | MAX_PRIORITY | USERESOURCEGRPID | USERESOURCEGRPNAME | CROSS_JOINS_ALLOWED
----------+------------+----------+----------------+--------------+--------------+--------------+------------------+--------------------+---------------------
AKAUL | | 0 | 0 | 0 | NONE | NONE | 1826461 | GRP3 | NULL
(1 row)
SYSTEM(ADMIN)=> \dU akaul
List of Groups a User is a member
USERNAME | GROUPNAME
----------+---------------------
AKAUL | DAVET2_GRP
AKAUL | DAVET_GRP
AKAUL | PUBLIC
(3 rows)
This question may have occurred because the distinction between user access groups and resource groups is not clear. The following table describes the purpose of each type of group.
| Type of Group | Purpose |
| User Access | When user accounts are assigned to user access groups, the administrator can efficiently manage access permissions and rights of database users. |
| Resource | When resource groups are configured and different groups of users submit work, the GRA scheduler ensures that each resource group receives its minimum configured percentage of resources. |
Groups (that is, user access groups) are used in most NPS environments. However, resource groups only work if the NPS administrator has created them. To do this, the administrator assigns a resource utilization percentage and users to the resource group.
When creating a new user account, you can specify that the user is a member of one or more GROUPS but when you specify the user as a member of a RESOURCEGROUP, you can only specify one RESOURCEGROUP.
SYSTEM(ADMIN)=> \h create user
Command: CREATE USER
Description: Creates a new database user
Syntax:
CREATE USER username
[WITH]
PASSWORD [ 'string' | NULL ]
[ IN GROUP groupname [, ...] ] -- Privileges groups
[ VALID UNTIL 'date' ]
[ ROWSETLIMIT integer ]
[ SESSIONTIMEOUT integer ]
[ QUERYTIMEOUT integer ]
[ DEFPRIORITY [ CRITICAL | HIGH | NORMAL | LOW | NONE ] ]
[ MAXPRIORITY [ CRITICAL | HIGH | NORMAL | LOW | NONE ] ]
[ SYSID uid ]
[ IN RESOURCEGROUP resourcegroupname ] ] – Resource group
[ SECURITY LABEL '[level] : [category,]... : [cohort,]... ' ]
[ AUDIT CATEGORY [ NONE | 'category,...' ] ]
[ COLLECT HISTORY [ ON | OFF | DEFAULT ] ]
[ CONCURRENT SESSIONS integer ]
[ ACCESS TIME [ ALL | DEFAULT | ( access_time,... ) ]
For more information about resource groups and workload management features, refer to the NPS Administrator's Guide.
Historical Number
NZ997036
Was this topic helpful?
Document Information
More support for:
IBM PureData System
Software version:
1.0.0
Document number:
462471
Modified date:
17 October 2019
UID
swg21570169