Skip to main content

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: 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

  • Map number 1 is named Master

    thismap.Global: ^rINDEXSQL

  • ^rINDEXSQL("sqlidx",1,{INFORMATION_SCHEMA.STATEMENTS.Hash},"priv",{Relation})
    =
FeedbackOpens in a new tab