Class Reference
IRIS for UNIX 2019.2
InterSystems: The power behind what matters   
Documentation  Search
  [%SYS] >  [Security] >  [SQL]
Private  Storage   

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
4


Summary

Methods
Help XMLDTD XMLExport XMLExportToStream
XMLExportToString XMLNew XMLSchema XMLSchemaNamespace
XMLSchemaType


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


Copyright (c) 2019 by InterSystems Corporation. Cambridge, Massachusetts, U.S.A. All rights reserved. Confidential property of InterSystems Corporation.