Skip to main content

%Library.SQLCatalogPriv

Class %Library.SQLCatalogPriv [ Not Hidden, System = 3 ]

SQL Catalog Queries - Privileged

Parameters​

SQLPUBLICSECURITY​

Parameter SQLPUBLICSECURITY = "{""SQLCatalogPriv_SQLUsers"":""E""}";

Methods​

SQLRolesExecute​

ClassMethod SQLRolesExecute(ByRef %q As %Binary) As %Status [ Internal ]

Get a list of all SQL Roles. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SQLRoles Procedure %SQLCatalogPriv_SQLRoles() Takes no parameters Returns all SQL Roles defined ROWSPEC = ROLE_NAME:%Library.String - Name of the role DESCRIPTION:%Library.String - Role's Desription CREATED_BY:%Library.String - SQL User who created the Role ESCALATION_ONLY:%Library.Boolean - Can this role be assigned at login, or can it only be used for escalation? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

SQLRolesFetch​

ClassMethod SQLRolesFetch(ByRef %q As %Binary, ByRef Row As %List, AtEnd As %Integer) As %Status [ Internal ]

SQLRolesClose​

ClassMethod SQLRolesClose(%q As %Library.Binary) As %Library.Status [ Internal ]

SQLRolePrivilegesExecute​

ClassMethod SQLRolePrivilegesExecute(ByRef %q As %Binary, role As %String = "") As %Status [ Internal ]

Get a list of Privileges granted to a Role -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SQLRolePrivleges Procedure %SQLCatalogPriv_SQLRolePrivileges('rolename') Takes 1 %String/VARCHAR type parameter which is the name of a Role. Returns all privileges granted to the role. ROWSPEC = TYPE:%String - TABLE or VIEW or PROCEDURE NAME:%String - Name of the object with privs granted to the role PRIVILEGE:%String - Privilege granted GRANTED_BY:%String - SQL user name who granted the privilege GRANT_OPTION:%String - 'Yes' or 'No', privilege granted with grant option -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

SQLRolePrivilegesFetch​

ClassMethod SQLRolePrivilegesFetch(ByRef %q As %Binary, ByRef Row As %List, AtEnd As %Integer) As %Status [ Internal ]

SQLRolePrivilegesClose​

ClassMethod SQLRolePrivilegesClose(%q As %Library.Binary) As %Status [ Internal ]

SQLRoleUserExecute​

ClassMethod SQLRoleUserExecute(ByRef %q As %Binary, role As %String = "") As %Status [ Internal ]

Get a list of all Users/Roles granted a Role. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SQLRoleUser Procedure %SQLCatalogPriv_SQLRoleUser('rolename') Takes 1 %String/VARCHAR type parameter which is the name of a Role. Returns all SQL Users granted the role ROWSPEC = NAME:%Library.String - Name of the SQL user granted the role TYPE:%Library.String - ROLE or USER, type of UID it is granted too -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

SQLRoleUserFetch​

ClassMethod SQLRoleUserFetch(ByRef %q As %Binary, ByRef Row As %List, AtEnd As %Integer) As %Status [ Internal ]

SQLRoleUserClose​

ClassMethod SQLRoleUserClose(%q As %Library.Binary) As %Status [ Internal ]

SQLUsersExecute​

ClassMethod SQLUsersExecute(ByRef %q As %Binary) As %Status [ Internal ]

Get a list of all Users. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SQLUsers Procedure %SQLCatalogPriv_SQLUsers() Takes no parameters Returns a list of SQL users: ROWSPEC = USERNAME:%Library.String - Name of the SQL user DESCRIPTION:%Library.String - SQL User description ENABLED:%Library.String - Yes/No: is user definition enabled? NAMESPACE:%Library.String - User's Namespace ROUTINE:%Library.String - Routine -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

SQLUsersFetch​

ClassMethod SQLUsersFetch(ByRef %q As %Binary, ByRef Row As %List, AtEnd As %Integer) As %Status [ Internal ]

SQLUsersClose​

ClassMethod SQLUsersClose(%q As %Library.Binary) As %Status [ Internal ]

SQLUserExistsExecute​

ClassMethod SQLUserExistsExecute(ByRef %q As %Binary, user As %String = "") As %Status [ Internal ]

If the user exists, return the username; otherwise nothing -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SQLUserExists Procedure %SQLCatalogPriv_SQLUserExists('username') Takes 1 %String/VARCHAR type parameter which is the name of an SQL user. Returns the SQL username if the user exists, otherwise nothing: ROWSPEC = USER_NAME:%String - Name of the SQL user -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

SQLUserExistsFetch​

ClassMethod SQLUserExistsFetch(ByRef %q As %Binary, ByRef Row As %List, AtEnd As %Integer) As %Status [ Internal ]

SQLUserExistsClose​

ClassMethod SQLUserExistsClose(%q As %Binary) As %Status [ Internal ]

SQLUserPrivsExecute​

ClassMethod SQLUserPrivsExecute(ByRef %q As %Binary, user As %String = "") As %Status [ Internal ]

Get a list of Privileges granted to a SQL User -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SQLUserPrivs Procedure %SQLCatalogPriv_SQLUserPrivs('username') Takes 1 %String/VARCHAR type parameter which is the name of a SQL User. Returns all privileges granted to the user. ROWSPEC = TYPE:%Library.String - TABLE, VIEW, STORED PROCEDURE NAME:%Library.String - Name of the item with privs granted to the user PRIVILEGE:%Library.String - Privilege granted GRANTED_BY:%Library.String - SQL user name who granted the privilege GRANT_OPTION:%Library.String - 'Yes' or 'No', privilege granted with grant option GRANTED_VIA:%Library.String - Direct, SuperUser, Role, _PUBLIC - How was the user granted the priv -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

SQLUserPrivsFetch​

ClassMethod SQLUserPrivsFetch(ByRef %q As %Binary, ByRef Row As %List, AtEnd As %Integer) As %Status [ Internal ]

SQLUserPrivsClose​

ClassMethod SQLUserPrivsClose(%q As %Library.Binary) As %Status [ Internal ]

SQLUserRoleExecute​

ClassMethod SQLUserRoleExecute(ByRef %q As %Binary, user As %String = "") As %Status [ Internal ]

Get a list of all Roles granted to an SQL User. -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SQLUserRole Procedure %SQLCatalogPriv_SQLUserRole('username') Takes 1 %Library.String/VARCHAR type parameter which is the name of a SQL user. Returns all Roles granted to the user ROWSPEC = ROLE_NAME:%Library.String - Name of the role granted to the user ADMIN_OPTION:%Library.Boolean - 1/0 Role granted with Admin Option? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

SQLUserRoleFetch​

ClassMethod SQLUserRoleFetch(ByRef %q As %Binary, ByRef Row As %List, AtEnd As %Integer) As %Status [ Internal ]

SQLUserRoleClose​

ClassMethod SQLUserRoleClose(%q As %Library.Binary) As %Status [ Internal ]

SQLUserSysPrivsExecute​

ClassMethod SQLUserSysPrivsExecute(ByRef %q As %Library.Binary, user As %Library.String = "") As %Library.Status [ Internal ]

Get all System Privileges granted to the user/role 'user' -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- SQLUserSysPriv Procedure %SQLCatalogPriv_SQLUserSysPrivs('username') Takes 1 %String/VARCHAR type parameter which is the name of an SQL User or Role. Returns all system privileges granted to a user or role ROWSPEC = PRIVILEGE:%Library.String - Name of the system privilege granted ADMIN_OPTION:%Library.String - 'Yes' or 'No' whether the privilege was granted with admin option GRANTED_VIA:%Library.String - Direct, SuperUser, Role, _PUBLIC - How was the user granted the priv -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

SQLUserSysPrivsFetch​

ClassMethod SQLUserSysPrivsFetch(ByRef %q As %Library.Binary, ByRef Row As %Library.List, AtEnd As %Library.Integer) As %Library.Status [ Internal ]

SQLUserSysPrivsClose​

ClassMethod SQLUserSysPrivsClose(ByRef %q As %Library.Binary) As %Library.Status [ Internal ]