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-205
Examples of GRANT EXECUTE
Examples of GRANT EXECUTE
•
Suppose that the super ID on behalf of the owner of the SPJ, 'SYSMGT.ANDY',
grants EXECUTE and WITH GRANT OPTION privileges on ADJUSTSALARY to
two other users, 'SYSMGT.BEN' and 'SYSMGT.JASON':
GRANT EXECUTE
ON PROCEDURE samdbcat.persnl.adjustsalary
TO 'SYSMGT.BEN', 'SYSMGT.JASON'
WITH GRANT OPTION
BY 'SYSMGT.ANDY';
The users, 'SYSMGT.BEN' and 'SYSMGT.JASON,' can then issue EXECUTE
and WITH GRANT OPTION privileges to other users on the system. They can also
execute CALL statements.
•
The user 'SYSMGT.BEN' grants EXECUTE and WITH GRANT OPTION privileges
on spj1 to user 'HR.BETTY':
GRANT EXECUTE
ON PROCEDURE samdbcat.persnl.spj1
TO 'HR.BETTY'
WITH GRANT OPTION;
•
The user 'HR.BETTY' grants EXECUTE privilege on spj1 to some users in the
HR group:
GRANT EXECUTE
ON PROCEDURE samdbcat.persnl.spj1
TO 'HR.MIKE', 'HR.JOE', 'HR.HILDE';
•
The owner of spj2 grants EXECUTE privilege on that SPJ to all users of the
system:
GRANT EXECUTE
ON samdbcat.persnl.spj2
TO PUBLIC;
GRANT SECURITY_ADMIN Statement
Considerations for GRANT SECURITY_ADMIN
Examples of GRANT SECURITY_ADMIN
The GRANT SECURITY_ADMIN statement designates a specified user as a security
administrator.
authid
specifies the authorization ID whom you are designating a Security Administrator.
Authorization IDs identify users during the processing of SQL statements. The
authorization ID must be a valid Guardian user name, enclosed in double quotes.
GRANT SECURITY_ADMIN to authid