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
Read syntax diagramSkip visual syntax diagram
Type-Level Privileges

|--+-USAGE ON TYPE--type_name-+---------------------------------|
   '-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
Parent topic: REVOKE statement
Copyright© 2021 HCL Technologies Limited