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-249
Examples of GRANT SECURITY_ADMIN
Metadata Version Requirements
The GRANT SECURITY_ADMIN statement requires system metadata version 3100 or
greater. If the statement is executed with lower versions of the system metadata, a
SQL error 25223 is generated.
Examples of GRANT SECURITY_ADMIN
•
The following example designates the Super ID as a Security Administrator:
GRANT SECURITY_ADMIN TO "SUPER.SUPER";
•
The following example designates the user, SECADMIN.USER1, as a Security
Administrator:
GRANT SECURITY_ADMIN TO "SECADMIN.USER1";