SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Statements

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001

2-194

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;

Security Administrators

=======================

SECADMIN.USER1

SECADMIN.USER2

--- SQL operation complete.

•

The following example lists the security administrators when one of the security

administrators is no longer in the system USERID file: