The metrics in this category provide information regarding each instance of a server login possessing a system role. One row is added for each role granted to each login. For example, if a single server user is granted sa_role, sso_role, and oper_role, three rows are added to sysloginroles associated with that user's system user ID (suid). Data from this metric is uploaded only if the severity has reached WARNING state.
Collection Frequency - Every 24 hour
Table 3-14 Database Login Roles Metrics
| Metric | Description | Default Warning Threshold | Default Critical Threshold | Alert Text |
|---|---|---|---|---|
|
Role Name |
Name of the role. |
Not Defined |
Not Defined |
User %Name% (with SUID %SUID%) has been granted server role of %RoleName%. |
Table 3-15 Database Login Roles Metrics
| Metric | Description and User Action |
|---|---|
|
SUID |
System user ID. |
|
Name |
Name of the role. |
|
Server Role ID |
Server role identifier. |