Skip to main content

%CSP.UI.Component.SQLPrivileges

class %CSP.UI.Component.SQLPrivileges extends %ZEN.Component.component, %CSP.UI.Component.SelectBoxUtils

Component for editing SQL Privileges on the User and Role edit pages

Property Inventory

Method Inventory

Properties

property PID as %ZEN.Datatype.string (ZENEXPRESSION = 1);
Name of the User/Role being edited
Property methods: PIDDisplayToLogical(), PIDGet(), PIDIsValid(), PIDLogicalToDisplay(), PIDLogicalToOdbc(), PIDNormalize(), PIDSet()
property namespace as %ZEN.Datatype.string;
Property methods: namespaceDisplayToLogical(), namespaceGet(), namespaceIsValid(), namespaceLogicalToDisplay(), namespaceLogicalToOdbc(), namespaceNormalize(), namespaceSet()
property nsDisplayList as %ZEN.Datatype.string;
Property methods: nsDisplayListDisplayToLogical(), nsDisplayListGet(), nsDisplayListIsValid(), nsDisplayListLogicalToDisplay(), nsDisplayListLogicalToOdbc(), nsDisplayListNormalize(), nsDisplayListSet()
property nsValueList as %ZEN.Datatype.string;
Property methods: nsValueListDisplayToLogical(), nsValueListGet(), nsValueListIsValid(), nsValueListLogicalToDisplay(), nsValueListLogicalToOdbc(), nsValueListNormalize(), nsValueListSet()
property readOnly as %ZEN.Datatype.boolean (ZENEXPRESSION = 1) [ InitialExpression = 0 ];
If true, tables are for display only
Property methods: readOnlyDisplayToLogical(), readOnlyGet(), readOnlyIsValid(), readOnlyLogicalToDisplay(), readOnlyLogicalToOdbc(), readOnlyLogicalToXSD(), readOnlyNormalize(), readOnlySet(), readOnlyXSDToLogical()

Methods

method %DrawHTML()
The %DrawHTML method draws the initial HTML for this component.
method AssignPrivs(PID As %String, Privs As %String, GrantOption As %Boolean, Namespace As %String) as %String [ ZenMethod ]
Assign a Role to a User or change the grant option on a User's existing Role PID: User name RoleList: Comma-delimited list of roles to change In case user selected roles longer than 32K, we break them into 100 items a piece before sending to the server to avoid error GrantOption: 1 - Add grant option, 0 - Remove grant option
method RemoveAllPrivs(PID As %String, Namespace As %String) as %String [ ZenMethod ]
Remove all roles from a user Create a comma-delimited list of the user's roles and send it to RemoveRole()
method RemovePriv(PID As %String, Privs As %String, Namespace As %String) as %String [ ZenMethod ]
Remove a Role from a User PID: User name RoleList: Comma-delimited list of roles to remove In case user selected roles longer than 32K, we break them into 100 items a piece before sending to the server to avoid error
clientmethod changeNS(sel) [ Language = javascript ]
clientmethod doAssignPriv(grantOption) [ Language = javascript ]
clientmethod doChangeGrantOption(priv, isChecked) [ Language = javascript ]
clientmethod doRemoveAllPrivs() [ Language = javascript ]
clientmethod doRemovePriv(priv) [ Language = javascript ]

Inherited Members

Inherited Properties

Inherited Methods

FeedbackOpens in a new tab