This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?


persistent class INFORMATION.SCHEMA.STATEMENTPRIVOBJECTS extends %Library.Persistent, %XML.Adaptor


Child class of INFORMATION.SCHEMA.STATEMENTS, the SQL Objects that have privileges required for this statement

Property Inventory


parameter READONLY = 1;
Inherited description: READONLY = 1 means that objects can be created, opened but not saved or deleted. Tables are projected to SQL as READONLY.


relationship Actions as array of INFORMATION.SCHEMA.STATEMENTPRIVACTIONS [ InitialExpression = $listbuild("INFORMATION.SCHEMA.STATEMENTPRIVACTIONS","Relation",+$this,"children",1,1) , Transient , Inverse = Relation , Cardinality = children ];
Property methods: ActionsGet(), ActionsGetObject(), ActionsGetObjectId(), ActionsGetSwizzled(), ActionsIsEmpty(), ActionsIsValid(), ActionsNewObject(), ActionsRClose(), ActionsRExec(), ActionsRFetch(), ActionsRelate(), ActionsSQLCompute(), ActionsSet(), ActionsUnRelate()
property Relation as %String (MAXLEN = 130) [ Required ];
SQL Privilege Object name for relatitions for this statement that will need privilege on to run. Note, the name of the relation is always stored in uppercase. This format is typically , table-type is 1 for tables, 3 for views. iqn is internal qualified name
Property methods: RelationDisplayToLogical(), RelationGet(), RelationIsValid(), RelationLogicalToDisplay(), RelationLogicalToOdbc(), RelationNormalize(), RelationSet()
relationship Statements as INFORMATION.SCHEMA.STATEMENTS [ Required , Inverse = PrivilegeRelations , Cardinality = parent ];
Reference to the INFORMATION_SCHEMA.STATEMENTS row this is a child of
Property methods: StatementsCheck(), StatementsDelete(), StatementsGet(), StatementsGetObject(), StatementsGetObjectId(), StatementsGetSwizzled(), StatementsIsValid(), StatementsNewObject(), StatementsOnDelete(), StatementsRClose(), StatementsRExec(), StatementsRFetch(), StatementsRelate(), StatementsSQLCompute(), StatementsSet(), StatementsSetObject(), StatementsSetObjectId(), StatementsUnRelate(), StatementsUnSwizzle()


index (StatementRelationsIDKey on Relation) [IdKey, Type = key];
Index methods: StatementRelationsIDKeyCheck(), StatementRelationsIDKeyDelete(), StatementRelationsIDKeyExists(), StatementRelationsIDKeyOpen(), StatementRelationsIDKeySQLCheckUnique(), StatementRelationsIDKeySQLExists(), StatementRelationsIDKeySQLFindPKeyByConstraint(), StatementRelationsIDKeySQLFindRowIDByConstraint()

Inherited Members

Inherited Methods


Gray indicates storage defined by superclasses.

Storage Model: CacheSQLStorage

Maps: 1

  • Map number 1 is named Master

    thismap.Global: ^rINDEXSQL

  • ^rINDEXSQL("sqlidx",1,{INFORMATION_SCHEMA.STATEMENTS.Hash},"priv",{Relation})