This is documentation for Caché & Ensemble.

For information on converting to InterSystems IRIS, see the InterSystems IRIS Adoption Guide and the InterSystems IRIS In-Place Conversion Guide, both available on the WRC Distributions page (login required).

Home > Class Reference > %SYS namespace > INFORMATION.SCHEMA.STATEMENTPRIVOBJECTS

INFORMATION.SCHEMA.STATEMENTPRIVOBJECTS

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

SQL Table Name: INFORMATION_SCHEMA.STATEMENT_PRIV_OBJECTS

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

Property Inventory

Parameters

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.

Properties

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()

Indexes

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

Inherited Members

Inherited Methods

Storage

Gray indicates storage defined by superclasses.

Storage Model: CacheSQLStorage

Maps: 1

FeedbackOpens in a new window