Type-Level Privileges

You can revoke two privileges on data types:
  • The Usage privilege on a user-defined data type
  • The Under privilege on a named ROW type
Type-Level Privileges

1  USAGE ON TYPE type_name
1  UNDER ON TYPE row_type
Element Description Restrictions Syntax
row_type Named ROW type for which to revoke Under privilege Must exist Data Type, p. Data Type
type_name User-defined type for which to revoke Usage privilege Must exist Data Type, p. Data Type