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-325

REVOKE SECURITY_ADMIN Statement

Considerations for REVOKE SECURITY_ADMIN

Examples of REVOKE SECURITY_ADMIN

The REVOKE SECURITY_ADMIN statement removes the Security Administrator

designation from a specified user.

authid

specifies the authorization ID from whom you are removing the Security

Administrator designation. Authorization IDs identify users during the processing of

SQL statements. The authorization ID must be a valid Guardian user name,

enclosed in double quotes.

userid

specifies the authorization ID from whom you are removing the Security

Administrator designation. The userid is any legal Guardian userid (group,user)

enclosed in double quotes (for example, “255,255”). The userid is not required to

be in the system USERID file. The userid option provides a means of revoking the

Security Administrator designation from a user that has been deleted from the

USERID file.

Considerations for REVOKE SECURITY_ADMIN

Authorization Requirements

If the Security Administrator's Group is empty, only the Super ID may execute the

REVOKE SECURITY_ADMIN statement. Otherwise, only a Security Administrator may

execute this statement.

Metadata Version Requirements

The REVOKE 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 REVOKE SECURITY_ADMIN

•

The following example removes the Security Administrator designation from the

user, SECADMIN.USER1:

REVOKE SECURITY_ADMIN from "grantee"

grantee is:

authid | userid