GRANT CREATE <object-type>
TO {[USER] username | [ROLE] rolename}
[WITH GRANT OPTION];

GRANT ALTER ANY <object-type>
TO {[USER] username | [ROLE] rolename}
[WITH GRANT OPTION];

GRANT DROP ANY <object-type>
TO {[USER] username | [ROLE] rolename}
[WITH GRANT OPTION];

REVOKE [GRANT OPTION FOR] CREATE <object-type>
FROM {[USER] username | [ROLE] rolename};

REVOKE [GRANT OPTION FOR] ALTER ANY <object-type>
FROM {[USER] username | [ROLE] rolename};

REVOKE [GRANT OPTION FOR] DROP ANY <object-type>
FROM {[USER] username | [ROLE] rolename};

GRANT CREATE DATABASE
TO {[USER] username | [ROLE] rolename}
[WITH GRANT OPTION];

GRANT ALTER DATABASE
TO {[USER] username | [ROLE] rolename}
[WITH GRANT OPTION];

GRANT DROP DATABASE
TO {[USER] username | [ROLE] rolename}
[WITH GRANT OPTION];

REVOKE [GRANT OPTION FOR] CREATE DATABASE
FROM {[USER] username | [ROLE] rolename};

REVOKE [GRANT OPTION FOR] ALTER DATABASE
FROM {[USER] username | [ROLE] rolename};

REVOKE [GRANT OPTION FOR] DROP DATABASE
FROM {[USER] username | [ROLE] rolename};

<object-type> ::= {
  CHARACTER SET |
  COLLATION |
  DOMAIN |
  EXCEPTION |
  FILTER |
  FUNCTION |
  GENERATOR |
  PACKAGE |
  PROCEDURE |
  ROLE |
  SEQUENCE |
  TABLE |
  VIEW
}

GRANT CREATE PROCEDURE TO ALEX;
GRANT ALTER ANY PROCEDURE TO ALEX;
GRANT CREATE PROCEDURE TO ALEX;       -- здесь должно быть FUNCTION
GRANT ALTER ANY PROCEDURE TO ALEX;  -- здесь должно быть FUNCTION