InterSystems IRIS Data Platform 2020.4 > Class Reference > %SYS namespace > Security.SQL

Security.SQL

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

Class wrapper for SQL security to provide queries, etc.

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

Inherited Members

Inherited Methods (Including Private)

Feedback