GRANT OBJECT PRIVILEGE
Grants object privileges to one or more idents.
The specified object privilege is granted to the ident(s) listed. When
WITH GRANT OPTIONis specified, the ident may in turn grant the specified privilege to another ident. If the privilege is granted to a
GROUPident, all members of the group receive the specified privilege.
The object privileges are as follows:
Grant usage on a domain or user defined type allows the ident(s) to use the domain or the user defined type where a data type would normally be specified. This includes, amongst others, table definitions, routine definitions and cast expression.
When a grant usage on type statement is executed, this will also incur that the ident(s) will receive execute on all functions, on which the grantor has execute privilege with grant option, that were created implicitly when the user defined type was created.
The grantor must have grant option on the privilege.
If the grantor loses his grant option, any privileges he has granted using the option are automatically revoked.
An ident may not grant privileges to himself.
ExampleGRANT EXECUTE ON FUNCTION capitalize TO mimer_admin_group;
SQL-2016 Core Fully compliant. SQL-2016 Features outside core Feature F251, "Domain support" support for grant usage on domain.Feature F690, "Collation support" support for grant usage on collation. Mimer SQL extension Support for use of MEMBER, EXECUTE (on STATEMENT and PROGRAM), SEQUENCE and TABLE are Mimer SQL extensions.
Mimer Information Technology AB
Phone: +46 18 780 92 00