Authorities and privileges for user defined types tasks


Task Authorities and privileges
To create a distinct type You must have one of the following authorizations:
  • SYSADM authority
  • DBADM authority on the database in which you want the distinct type stored
  • One of the following privileges:
    • IMPLICIT_SCHEMA authority on the database, if the implicit or explicit schema name of the distinct type does not exist
    • CREATIN privilege on the schema, if the schema name of the distinct type exists