SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements

HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005

2-233

GET ALL SECURITY_ADMINS Statement

Considerations for GET ALL SECURITY_ADMINS

Examples of GET ALL SECURITY_ADMINS

The GET ALL SECURITY_ADMINS statement lists the users in the Security

Administrators Group.

GET ALL SECURITY_ADMINS is an SQL/MX extension.

Considerations for GET ALL SECURITY_ADMINS

Authorization Requirements

Any Guardian user may execute the GET ALL SECURITY_ADMINS statement.

Metadata Version Requirements

The GET ALL SECURITY_ADMINS statement requires system metadata version 3100

or greater. If the statement is executed with lower versions of the system metadata, a

SQL error is generated indicating that the SYSTEM_SECURITY_SCHEMA does not

exist.

Invalid Security Administrator User IDs

If a user ID that does not exist in the system USERID file is encountered while

processing the GET ALL SECURITY_ADMINS statement, it will be mapped to its

numeric representation. This situation can occur if an existing user ID is designated as

a security administrator and then later removed from the system USERID file without

revoking the security administrator designation.

Examples of GET ALL SECURITY_ADMINS

•

The following example lists the security administrators:

GET ALL SECURITY_ADMINS