Was this helpful?
iipermits Catalog
The iipermits catalog contains one or more entries for each permit defined. Because the permit definition can contain more than 240 characters, iipermits can contain more than one row for a single permit. The text may contain newlines and may be broken mid-word across rows.
Note:  Ingres Star does not currently support permits, so there are no rows in this catalog.
This table is keyed on object_name and object_owner:
Column Name
Data Type
Description
object_name
char(256)
The table or procedure name. Must be a valid name.
object_owner
char(32)
The owner of the table or procedure. Must be a valid name.
object_type
char(8)
The type of the object: T for a table or view; P for a database procedure.
create_date
char(25)
The permit’s creation date. This is a date field.
permit_user
char(32)
The username to which this permit applies.
permit_number
smallint
The number of this permit.
text_sequence
smallint
The sequence number for the text, numbered from 1.
text-segment
varchar (240)
The text of the permission definition.
Last modified date: 04/03/2024