Learning
Documentation
Community
Open Exchange
Global Masters
Home / Class Reference / %SYS namespace / Security.SQL
Private  Storage   

Security.SQL


abstract class Security.SQL extends
%SYSTEM.Help, %XML.Adaptor

Class wrapper for SQL security to provide queries, etc.

Inventory


Parameters Properties Methods Queries Indices ForeignKeys Triggers
12 4


Summary


Methods
%XMLGenerate Help PrivListClose PrivListExecute
PrivListFetch RoleUserListClose RoleUserListExecute RoleUserListFetch
SysPrivListClose SysPrivListExecute SysPrivListFetch UserRoleListClose
UserRoleListExecute UserRoleListFetch XMLAfterExport XMLBeforeExport
XMLDTD XMLExport XMLExportInternal XMLExportToStream
XMLExportToString XMLGetSchemaImports XMLImport XMLImportInternal
XMLIsObjectEmpty XMLNew XMLSchema XMLSchemaNamespace
XMLSchemaType


Methods


• classmethod PrivListClose(ByRef qHandle As %Binary) as %Status
• classmethod PrivListExecute(ByRef qHandle As %Binary) as %Status
• classmethod PrivListFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status
• classmethod RoleUserListClose(ByRef qHandle As %Binary) as %Status
• classmethod RoleUserListExecute(ByRef qHandle As %Binary) as %Status
• classmethod RoleUserListFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status
• classmethod SysPrivListClose(ByRef qHandle As %Binary) as %Status
• classmethod SysPrivListExecute(ByRef qHandle As %Binary) as %Status
• classmethod SysPrivListFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status
• classmethod UserRoleListClose(ByRef qHandle As %Binary) as %Status
• classmethod UserRoleListExecute(ByRef qHandle As %Binary) as %Status
• classmethod UserRoleListFetch(ByRef qHandle As %Binary, ByRef Row As %List, ByRef AtEnd As %Integer = 0) as %Status

Queries


• query PrivList()
Selects Namespace As %String, GrantOption As %String, ReltypeName As %String, PrivCode As %String, Grantee As %String, Grantor As %String, Value As %String
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
• query RoleUserList()
Selects Role As %String, User As %String, Value As %String
• query SysPrivList()
Selects Namespace As %String, GrantOption As %String, ReltypeName As %String, PrivCode As %String, Grantee As %String, Grantor As %String, Value As %String
Returns data under ^SYS("Security","SQL","syspriv",...) via macro $$$SecurityGlobalSQLSysPriv. Data is at $$$SecurityGlobalSQLSysPriv(Namespace,GrantOption,ReltypeName,PrivCode,Grantee,Grantor)=grant_option
• query UserRoleList()
Selects User As %String, Role As %String, Value As %String
Returns data under ^SYS("Security","SQL","user-role") via macro $$$SecurityGlobalSQLUserRole Data is ^SYS("Security","SQL","user-role",UserName,RoleName)=0 or 1