Security.SQLRoleGrantOption
persistent class Security.SQLRoleGrantOption extends %Library.Persistent, %XML.Adaptor, %SYSTEM.Help
SQL Table Name: Security.SQLRoleGrantOption
Defines whether a role is granted to the user/role with admin/grant option.
This mapping was added for SQL RoleGrantOption to take advantage of XML export, and not meant for direct Object access or query. Use the List or DirectRoles class queries instead.
Property Inventory
Method Inventory
Properties
property Grantable as %TinyInt (VALUELIST = ",0,1") [ Required ];
Grantable - 1/0, can this role be granted by the user
Property methods: GrantableDisplayToLogical(), GrantableGet(), GrantableIsValid(), GrantableLogicalToDisplay(), GrantableNormalize(), GrantableSet(), GrantableXSDToLogical()
property RoleGranted as %String (MAXLEN = 64, MINLEN = 1) [ Required ];
RoleGranted - Role that was granted to the user/role
Property methods: RoleGrantedDisplayToLogical(), RoleGrantedGet(), RoleGrantedIsValid(), RoleGrantedLogicalToDisplay(), RoleGrantedLogicalToOdbc(), RoleGrantedNormalize(), RoleGrantedSet()
property UserOrRole as %String (MAXLEN = 64, MINLEN = 1) [ Required ];
UserOrRole - User or Role the role was granted to
Property methods: UserOrRoleDisplayToLogical(), UserOrRoleGet(), UserOrRoleIsValid(), UserOrRoleLogicalToDisplay(), UserOrRoleLogicalToOdbc(), UserOrRoleNormalize(), UserOrRoleSet()
Methods
classmethod Export(FileName As %String = "SQLRoleGrantOptionExport.xml", ByRef NumExported As %Integer = 0) as %Status
This method exports SQLRoleGrantOption records to a file in xml format.
Parameters:
Filename - Output file name
NumExported (byref) - Returns number of records exported.
Parameters:
Filename - Output file name
NumExported (byref) - Returns number of records exported.
classmethod Import(FileName As %String, ByRef NumImported As %Integer, Flags As %Integer = 0) as %Status
Import SQLRoleGrantOption records from an xml file.
Parameters:
FileName - Filename to import Role records from
NumImported (byref) - Returns number of records imported
Flags - Control import
Bit 0 - Do not import records, just return count
Note: On failure, no records will be imported
Parameters:
FileName - Filename to import Role records from
NumImported (byref) - Returns number of records imported
Flags - Control import
Bit 0 - Do not import records, just return count
Note: On failure, no records will be imported
Queries
query DirectRoles(UserOrRole As %String)
SQL Query:
SELECT UserOrRole, RoleGranted, Grantable FROM Security.SQLRoleGrantOption WHERE (UserOrRole = :UserOrRole)
SELECT UserOrRole, RoleGranted, Grantable FROM Security.SQLRoleGrantOption WHERE (UserOrRole = :UserOrRole)
Given a User or Role name, return the roles and grant options for the roles granted directly to this UserOrRole
query List()
SQL Query:
SELECT UserOrRole, RoleGranted, Grantable FROM Security.SQLRoleGrantOption
SELECT UserOrRole, RoleGranted, Grantable FROM Security.SQLRoleGrantOption
Return the ID information for all SQL Role Grant Options
Indexes
index (IDKey on UserOrRole,RoleGranted) [IdKey, Type = key];
Index methods: IDKeyCheck(), IDKeyDelete(), IDKeyExists(), IDKeyOpen(), IDKeySQLCheckUnique(), IDKeySQLExists(), IDKeySQLFindPKeyByConstraint(), IDKeySQLFindRowIDByConstraint()
Inherited Members
Inherited Methods
- %AddToSaveSet()
- %AddToSyncSet()
- %BuildDeferred()
- %BuildDeferredBitString()
- %BuildDeferredIndices()
- %BuildDeferredRecord()
- %BuildIndicesAsync()
- %BuildIndicesAsyncResponse()
- %CheckConstraints()
- %CheckConstraintsForExtent()
- %ClassIsLatestVersion()
- %ClassName()
- %ComposeOid()
- %ConstructClone()
- %Delete()
- %DeleteExtent()
- %DeleteId()
- %DispatchClassMethod()
- %DispatchGetModified()
- %DispatchGetProperty()
- %DispatchMethod()
- %DispatchSetModified()
- %DispatchSetMultidimProperty()
- %DispatchSetProperty()
- %Exists()
- %ExistsId()
- %Extends()
- %GUID()
- %GUIDSet()
- %GetLock()
- %GetParameter()
- %GetSwizzleObject()
- %Id()
- %IsA()
- %IsModified()
- %IsNull()
- %KillExtent()
- %LockExtent()
- %LockId()
- %New()
- %NormalizeObject()
- %ObjectIsNull()
- %ObjectModified()
- %Oid()
- %OnBeforeAddToSync()
- %OnDeleteFinally()
- %OnDetermineClass()
- %OnOpenFinally()
- %OnSaveFinally()
- %Open()
- %OpenId()
- %OriginalNamespace()
- %PackageName()
- %PurgeIndices()
- %Reload()
- %RemoveFromSaveSet()
- %ResolveConcurrencyConflict()
- %RollBack()
- %Save()
- %SaveDirect()
- %SerializeObject()
- %SetModified()
- %SortBegin()
- %SortEnd()
- %SyncObjectIn()
- %SyncTransport()
- %UnlockExtent()
- %UnlockId()
- %ValidateIndices()
- %ValidateObject()
- %ValidateTable()
- Help()
- XMLDTD()
- XMLExport()
- XMLExportToStream()
- XMLExportToString()
- XMLNew()
- XMLSchema()
- XMLSchemaNamespace()
- XMLSchemaType()
Storage
Storage Model: SQLStorage
Maps: 1
Map number 1 is named Master
thismap.Global: ^*
^*($e(("^|$zu(221,2)|SECURITY"),2,*),"SQL","user-role",{UserOrRole},{RoleGranted})
|
= |
|