This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see How to Migrate to InterSystems IRIS, available on the WRC Distributions page (login required).

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