Class %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

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
	5	9

Summary

Properties
%condition	%import	%includeFiles	%page
%resource	PID	align	aux
avaList	composite	containerStyle	dragEnabled
dropEnabled	enclosingClass	enclosingStyle	error
height	hidden	hint	hintClass
hintStyle	id	index	label
labelClass	labelDisabledClass	labelStyle	name
namespace	nsDisplayList	nsValueList	onafterdrag
onbeforedrag	ondrag	ondrop	onhide
onrefresh	onshow	onupdate	parent
readOnly	selList	showLabel	slice
title	tuple	valign	visible
width	window

Methods
%AddToSaveSet	%Attr	%BindExport	%ClassIsLatestVersion
%ClassName	%ConstructClone	%DispatchClassMethod	%DispatchGetModified
%DispatchGetProperty	%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty
%DispatchSetProperty	%DrawComponentHTML	%DrawHTML	%DrawJSStrings
%EnclosingDivId	%Eval	%EvalC	%Extends
%ForceClientRender	%GetEventHandlers	%GetParameter	%GetXMLName
%IsA	%IsModified	%MakeId	%New
%NormalizeObject	%ObjectModified	%OnAddToPageAfter	%OnAddToPageBefore
%OnDrawEnclosingDiv	%OnDrawObjectProperties	%OnObjectSynch	%OnZENDeserialize
%OriginalNamespace	%PackageName	%QuoteValue	%QuoteValueL10N
%RemoveFromSaveSet	%Self	%SerializeObject	%SetModified
%ValidateObject	AssignPrivs	DrawArrows	DrawArrowsOld
DrawAvailableList	DrawSelectList	DrawUpArrowsOld	RemoveAllPrivs
RemovePriv	XMLDTD	XMLExport	XMLExportToStream
XMLExportToString	XMLNew	XMLSchema	XMLSchemaNamespace
XMLSchemaType	changeNS	clearList	doAssignPriv
doChangeGrantOption	doRemoveAllPrivs	doRemovePriv	doSelectBoxMove
doSelectBoxMoveAll	doSelectBoxMoveItem	doSelectBoxMoveList	dragFinishHandler
dragHandler	dragNotifyHandler	dragStartHandler	dropHandler
dropStartHandler	exposeComponent	findElement	fireOnUpdateEvent
getEnclosingDiv	getHidden	getHintElement	getLabelElement
getProperty	getSelList	getSettings	getType
invokeSuper	isOfType	makeId	onCreate
onDelete	onDisplayHandler	onEndModalHandler	onPopupAction
onRefreshContents	onSerialize	onStartModalHandler	onloadHandler
onunloadHandler	onupdateHandler	refreshContents	render
renderContents	renderSVG	setHidden	setOverlayMode
setProperty	startProgressBar	stopProgressBar

Properties

• property PID as %ZEN.Datatype.string(ZENEXPRESSION=1);

Name of the User/Role being edited

• property namespace as %ZEN.Datatype.string;

• property nsDisplayList as %ZEN.Datatype.string;

• property nsValueList as %ZEN.Datatype.string;

• property readOnly as %ZEN.Datatype.boolean(ZENEXPRESSION=1) [ InitialExpression = 0 ];

If true, tables are for display only

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

• method changeNS(sel) [ Language = javascript ]

• method doAssignPriv(grantOption) [ Language = javascript ]

• method doChangeGrantOption(priv, isChecked) [ Language = javascript ]

• method doRemoveAllPrivs() [ Language = javascript ]

• method doRemovePriv(priv) [ Language = javascript ]

Class Reference IRIS for UNIX 2024.1.2
Documentation Search