Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

For information on migrating to InterSystems IRISOpens in a new tab, see Why Migrate to InterSystems IRIS?

Security.SQL

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

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

FeedbackOpens in a new tab