Skip to main content

Security.SQL

Class Security.SQL Extends (%SYSTEM.Help, %XML.Adaptor) [ Abstract, Final, System = 4 ]

Class wrapper for SQL security to provide queries, etc.

Parameters​

SOURCECONTROL​

Parameter SOURCECONTROL [ Internal ] = {"Revision path: $Id: //iris/2024.3.0/databases/sys/cls/Security/SQL.xml#1 $"_$c(13,10)_"Last Change:   $DateTime: 2024/10/02 10:58:11 $"_$c(13,10)_"Changelist #:  $Change: 7247250 $"};

Methods​

PrivListExecute​

ClassMethod PrivListExecute(ByRef qHandle As %Binary) As %Status [ Internal ]

Returns data under ^SYS("Security","SQL","priv",...) via macro $$$SecurityGlobalSQLPriv. Global is organized as ^SYS("Security","SQL","priv",NAMESPACE,grant_option,(reltype,name),privcode,grantee,grantor)=grant_option

PrivListFetch​

ClassMethod PrivListFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ Internal, PlaceAfter = UserListExecute ]

PrivListClose​

ClassMethod PrivListClose(ByRef qHandle As %Binary) As %Status [ Internal, PlaceAfter = UserListFetch ]

SysPrivListExecute​

ClassMethod SysPrivListExecute(ByRef qHandle As %Binary) As %Status [ Internal ]

Returns data under ^SYS("Security","SQL","syspriv",...) via macro $$$SecurityGlobalSQLSysPriv. Data is at $$$SecurityGlobalSQLSysPriv(Namespace,GrantOption,ReltypeName,PrivCode,Grantee,Grantor)=grant_option

SysPrivListFetch​

ClassMethod SysPrivListFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ Internal, PlaceAfter = UserListExecute ]

SysPrivListClose​

ClassMethod SysPrivListClose(ByRef qHandle As %Binary) As %Status [ Internal, PlaceAfter = UserListFetch ]

UserRoleListExecute​

ClassMethod UserRoleListExecute(ByRef qHandle As %Binary) As %Status [ Internal ]

Returns data under ^SYS("Security","SQL","user-role") via macro $$$SecurityGlobalSQLUserRole Data is ^SYS("Security","SQL","user-role",UserName,RoleName)=0 or 1

UserRoleListFetch​

ClassMethod UserRoleListFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ Internal, PlaceAfter = UserRoleListExecute ]

UserRoleListClose​

ClassMethod UserRoleListClose(ByRef qHandle As %Binary) As %Status [ Internal, PlaceAfter = UserRoleListFetch ]

RoleUserListExecute​

ClassMethod RoleUserListExecute(ByRef qHandle As %Binary) As %Status [ Internal ]

RoleUserListFetch​

ClassMethod RoleUserListFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) As %Status [ Internal, PlaceAfter = RoleUserListExecute ]

RoleUserListClose​

ClassMethod RoleUserListClose(ByRef qHandle As %Binary) As %Status [ Internal, PlaceAfter = RoleUserListFetch ]