Class %CSP.UI.Portal.ColumnPriv

class %CSP.UI.Portal.ColumnPriv extends %ZEN.Component.page

Page to define SQL Table/View column privileges.

Parameters	Properties	Methods	Queries	Indices	ForeignKeys	Triggers
9	11	26

Summary

This is a Zen Page class. It belongs to the application %CSP.UI.Portal.Application.

Properties
%condition	%import	%includeFiles	%page
%resource	Column	Grantee	IncludeSystem
NAMESPACE	ObjName	ObjectType	Schema
SettingChanged	Table	TotalColumns	align
aux	backgroundTimerInterval	cellAlign	cellSize
cellStyle	cellVAlign	children	composite
containerStyle	cssLevel	disabled	dragAndDrop
dragEnabled	dropEnabled	enclosingClass	enclosingStyle
error	groupClass	groupStyle	height
hidden	hint	hintClass	hintStyle
id	index	label	labelClass
labelDisabledClass	labelPosition	labelStyle	layout
name	onafterdrag	onbeforedrag	onclick
ondrag	ondrop	onhide	onrefresh
onshow	onupdate	parent	showLabel
slice	tab	title	tuple
useSVG	useSoftModals	valign	visible
width	window	zenPersistentPopup

Methods
%%OIDGet	%AddChild	%AddChildAfter	%AddChildBefore
%AddComponent	%AddImportedComponents	%AddToSaveSet	%ApplyURLParms
%Attr	%BindExport	%ClassIsLatestVersion	%ClassName
%ConstructClone	%DispatchClassMethod	%DispatchGetModified	%DispatchGetProperty
%DispatchMethod	%DispatchSetModified	%DispatchSetMultidimProperty	%DispatchSetProperty
%DrawAutoLogout	%DrawClassDefinitions	%DrawComponentHTML	%DrawHTML
%DrawHTMLPage	%DrawJSStrings	%DrawObjectDefinitions	%EnclosingDivId
%EndBackgroundMethod	%EndScript	%Eval	%Extends
%ForceClientRender	%GetChildIndex	%GetComponent	%GetComponentById
%GetComponentByName	%GetEventHandlers	%GetLinks	%GetPageName
%GetParameter	%GetValueById	%GetValueByName	%GetXMLName
%IsA	%IsModified	%Link	%LinkCSS
%LinkScript	%MakeId	%New	%NormalizeObject
%ObjectModified	%OnAddToPageAfter	%OnAddToPageBefore	%OnAfterCreatePage
%OnBeforeCreatePage	%OnCreateApplication	%OnCreatePage	%OnDetermineCSSLevel
%OnDrawEnclosingDiv	%OnDrawHTMLBody	%OnDrawHTMLHead	%OnDrawHTMLMeta
%OnDrawObjectProperties	%OnFinishBackgroundTask	%OnMonitorBackgroundTask	%OnMutateChildren
%OnObjectSynch	%OnPreHTTP	%OnSubmit	%OnUseSoftModals
%OnZENDeserialize	%OriginalNamespace	%PackageName	%QuoteValue
%QuoteValueL10N	%RemoveChild	%RemoveChildren	%RemoveComponent
%RemoveFromSaveSet	%RunBackgroundMethod	%Self	%SerializeObject
%SetBackgroundMethodStatus	%SetErrorById	%SetErrorByName	%SetModified
%SetValueById	%SetValueByName	%SetValuesByName	%StartScript
%ValidateObject	%ZENVersion	ColumnEdit	ConvertParameter
Decrypt	DrawErrorBox	DrawTable	Encrypt
EscapeHTML	EscapeURL	GetColumns	HyperEventBody
HyperEventCall	HyperEventFrame	HyperEventHead	Include
InsertHiddenField	InsertHiddenFields	IsPrivate	Link
ListSchemas	ListTables	OnHTTPHeader	OnPage
OnPageError	OnPostHTTP	OnPostHyperEvent	OnPreHTTP
OnPreHyperEvent	Page	QuoteJS	RewriteURL
SaveData	ShowError	StartTimer	StopTimer
ThrowError	UnescapeHTML	UnescapeURL	UpdateDetails
XMLDTD	XMLExport	XMLExportToStream	XMLExportToString
XMLNew	XMLSchema	XMLSchemaNamespace	XMLSchemaType
addChild	addChildAfter	addChildBefore	addColumn
arrowClick	arrowClicked	arrowMoved	cancelPopup
changeCheck	changeSchema	changeSetting	changeTable
checkAll	childrenMutated	correctIELayering	createComponent
createComponentNS	deleteComponent	doButtons	doCancel
doDone	doSave	dragFinishHandler	dragHandler
dragNotifyHandler	dragStartHandler	dropHandler	dropStartHandler
editColumn	enableSave	endModal	exposeComponent
findElement	fireOnLoadEvent	fireOnResizeEvent	fireOnUnloadEvent
fireOnUpdateEvent	firePopupAction	getChildIndex	getComponent
getComponentById	getEnclosingDiv	getHidden	getHintElement
getLabelElement	getOpener	getProperty	getSettings
getType	gotoPage	invokeSuper	isOfType
launchPopupWindow	makeId	onCreate	onDelete
onDisplayHandler	onEndModalHandler	onPopupAction	onRefreshContents
onSerialize	onServerMethodCall	onServerMethodError	onServerMethodReturn
onStartModalHandler	ondisabledHandler	onkeydownHandler	onkeyupHandler
onlayoutHandler	onloadHandler	onlogoutHandler	onoverlayHandler
onresizeHandler	onunloadHandler	onupdateHandler	popupActionHandler
refreshContents	removeChild	render	renderContents
renderSVG	revokeColumn	setComponentId	setHidden
setOverlayMode	setProperty	setPropertyAll	setTraceOption
startModal	startProgressBar	stopProgressBar	toggleChecks

Parameters

• parameter APPLICATION = "%CSP.UI.Portal.Application";

Class name of application this page belongs to.

• parameter DOMAIN = "%Utility";

Domain used for localization.

• parameter PAGENAME = "Column Privileges";

Displayed name of this page.

• parameter PAGETITLE = "Column Privileges";

Display title of this page

• parameter TitleGrant = "click to change privilege";

• parameter cellValue1 = "º";

• parameter cellValue2 = "•";

• parameter cellValue3 = "-";

• parameter sPrivileges = "SELECT,INSERT,UPDATE,REFERENCES";

Properties

• property Column as %String;

Table column name if user is editing or revoking

• property Grantee as %String(ZENURL="$ID1");

User or Role whose privileges are being granted

• property IncludeSystem as %Boolean(ZENURL="IncludeSystem") [ InitialExpression = "0" ];

Flag indicating whether user checked the "Include System Items" checkbox.

• property NAMESPACE as %String(ZENURL="NAMESPACE");

Namespace indicating where the schemas/tables/views are coming from.

• property ObjName as %String(ZENURL="ObjName");

ObjName = null for Add, or Table name or View name for Edit

• property ObjectType as %String(ZENURL="ObjectType");

"TABLE" or "VIEW".

• property Schema as %String;

User selected schema name

• property SettingChanged as %Boolean [ InitialExpression = "0" ];

Indicate whether user has made any valid change

• property Table as %String;

User selected table name

• property TotalColumns as %Integer [ InitialExpression = "0" ];

Total number of existing columns for edit

• property tab as %String(ZENURL="tab");

tab number

Methods

• method %OnAfterCreatePage() as %Status

Set Locator bar and determine whether to show change password option.

• classmethod ColumnEdit(pSchema, pTable, pColumn) as %ZEN.proxyObject [ ZenMethod ]

When editing existing column priv, this method loads existing column priv into check boxes

• classmethod DrawErrorBox(tObj)

Draws error box for object error message.

• method DrawTable(seed As %String) as %Status

Draws table for existing table column priv allowing user to edit or revoke.

• classmethod GetColumns(Grantee, Schema, Table, IncludeSystem) as %String

Return existing columns

• method ListSchemas(pRS As %Library.ResultSet, Output tSC As %Status, pInfo As %ZEN.Auxiliary.QueryInfo) as %Boolean

Method for executing the schemas query.

• method ListTables(pRS As %Library.ResultSet, Output tSC As %Status, pInfo As %ZEN.Auxiliary.QueryInfo) as %Boolean

Method for executing the tables query.

• classmethod SaveData(pNamespace, pObjName, pGrantee, pObjectType, pSchema, pTable, pColumns="", pPrivs="", pGrants="", pRevoke, pIncludeSystem) as %String [ ZenMethod ]

Save column priv data to server If this is to revoke column priv, then pRevoke = 1, pPrivs and pGrant will be null.

• classmethod UpdateDetails(NAMESPACE, Schema, Table, Grantee, IncludeSystem) as %Boolean [ ZenMethod ]

Load fields into Available/Selected list boxes.

• method addColumn() [ Language = javascript ]

User clicked "Add Columns" to add more columns to existing schema.table

• method arrowClick(from, to) [ Language = javascript ]

Moving a list item from one box to the next, then remove it from the original box

• method arrowClicked(id) [ Language = javascript ]

• method arrowMoved(thisObj) [ Language = javascript ]

User double clicked one of the listboxes. You can use this if you need extra work done.

• method changeCheck(id, g) [ Language = javascript ]

User changed checks. Update flag.

• method changeSchema() [ Language = javascript ]

User changed or selected a schema. Load Table list based on the schema selected.

• method changeSetting() [ Language = javascript ]

User changed something. Update flag.

• method changeTable() [ Language = javascript ]

User selected a table. Load Available/Selected list boxes.

• method checkAll() [ Language = javascript ]

Check if Priv or Grant are all checked. check chkPriv/chkGrant if all its checkboxes are checked; uncheck if at least one is unchecked.

• method doButtons() [ Language = javascript ]

Update buttons after successful save.

• method doCancel() [ Language = javascript ]

Close this window.

• method doDone() [ Language = javascript ]

Refresh opener then close this window.

• method doSave() [ Language = javascript ]

User clicked Save.

• method editColumn(column) [ Language = javascript ]

User clicked "Edit" to edit existing column priv

• method enableSave() [ Language = javascript ]

Enable the Save button when user made valid changes.

• method revokeColumn(column) [ Language = javascript ]

User clicked "Revoke" to revoke existing column priv

• method toggleChecks(g) [ Language = javascript ]

User checked the Privilege/Grant Admin check. Check all.


[BASEXML] > [%CSP] > [UI] > [Portal] > [ColumnPriv]		Private Storage