User+Roles.SP Details

Element Details: User+Roles.SP

Available in: Logi Info

Source code name: UserRoles.SP

The UserRoles element controls how the server determines the current user's list of Roles or Groups.

Use UserRoles.SP to get the list from your own custom database. In the Source attribute, enter a Stored Procedure which returns roles in the first column. Multiple roles can be obtained either by having one role per record, or multiple roles can be comma-delimited in a single record.

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

Command

UserDefined

(Required) When this is an attribute of Procedure.SP, provide the name of a Stored Procedure that returns a single or no values. Use this element for procedures that execute UPDATEs, INSERTs, and other database actions. When this is an attribute of DataLayer.SP, provide the name of a Stored Procedure that returns a result set of some number of data rows. If working with Oracle Packages, provide the Package name, then a period, then the Procedure name. For example, "myPackage.myProcedure".

ConnectionID

UserDefined

Specifies a connection to a data source that is defined in the Settings. For elements connecting to relational databases, default is the first Connection element in _settings.lgx.

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

PARENT ELEMENTS

Click element to drill down for more information.

CHILD ELEMENTS

Click element to drill down for more information.

Calculated Column
Condition Filter

SP Auto Parameters
SP Input Parameters

SP Parameters