FETCH_USER Procedure

This procedure fetches a user account record. To execute this procedure, the current user must have administrative privileges in the workspace. Three overloaded versions of this procedure exist, each with a distinct set of allowed parameters or signatures.

Fetch_user Procedure Signature 1:

Syntax

FETCH_USER (
    p_user_id                      NUMBER                  IN,
    p_workspace                    VARCHAR2                OUT,
    p_user_name                    VARCHAR2                OUT,
    p_first_name                   VARCHAR2                OUT,
    p_last_name                    VARCHAR2                OUT,
    p_web_password                 VARCHAR2                OUT,
    p_email_address                VARCHAR2                OUT,
    p_start_date                   VARCHAR2                OUT,
    p_end_date                     VARCHAR2                OUT,
    p_employee_id                  VARCHAR2                OUT,
    p_allow_access_to_schemas      VARCHAR2                OUT,
    p_person_type                  VARCHAR2                OUT,
    p_default_schema               VARCHAR2                OUT,
    p_groups                       VARCHAR2                OUT,
    p_developer_role               VARCHAR2                OUT,
    p_description                  VARCHAR2                OUT );

Parameters

Table: Fetch_User Parameters Signature 1 describes the parameters available in the FETCH_USER procedure.

Fetch_User Parameters Signature 1

Parameter	Description
`p_user_id`	Numeric primary key of the user account
`p_workspace`	The name of the workspace
`p_user_name`	Alphanumeric name used for login
`p_first_name`	Informational
`p_last_name`	Informational
`p_web_password`	Obfuscated account password
`p_email_address`	Email address
`p_start_date`	Unused
`p_end_date`	Unused
`p_employee_id`	Unused
`p_allow_access_to_schemas`	A list of schemas assigned to the user's workspace to which user is restricted
`p_person_type`	Unused
`p_default_schema`	A database schema assigned to the user's workspace, used by default for browsing
`p_groups`	List of groups of which user is a member
`p_developer_role`	Unused
`p_description`	Informational

Fetch_user Procedure Signature 2:

Syntax

FETCH_USER (
    p_user_id                      NUMBER                  IN,
    p_workspace                    VARCHAR2                OUT,
    p_user_name                    VARCHAR2                OUT,
    p_first_name                   VARCHAR2                OUT,
    p_last_name                    VARCHAR2                OUT,
    p_email_address                VARCHAR2                OUT,
    p_groups                       VARCHAR2                OUT,
    p_developer_role               VARCHAR2                OUT,
    p_description                  VARCHAR2                OUT );

Parameters

Table: Fetch_User Parameters Signature 2 describes the parameters available in the FETCH_USER procedure.

Fetch_User Parameters Signature 2

Parameter	Description
`p_user_id`	Numeric primary key of the user account
`p_user_name`	Alphanumeric name used for login
`p_first_name`	Informational
`p_last_name`	Informational
`p_web_password`	Obfuscated account password
`p_email_address`	Email address
`p_groups`	List of groups of which user is a member
`p_developer_role`	Unused
`p_description`	Informational

FETCH_USER Procedure Signature 3

Syntax

FETCH_USER (
    p_user_id                      NUMBER                  IN,
    p_workspace                    VARCHAR2                OUT,
    p_user_name                    VARCHAR2                OUT,
    p_first_name                   VARCHAR2                OUT,
    p_last_name                    VARCHAR2                OUT,
    p_web_password                 VARCHAR2                OUT,
    p_email_address                VARCHAR2                OUT,
    p_start_date                   VARCHAR2                OUT,
    p_end_date                     VARCHAR2                OUT,
    p_employee_id                  VARCHAR2                OUT,
    p_allow_access_to_schemas      VARCHAR2                OUT,
    p_person_type                  VARCHAR2                OUT,
    p_default_schema               VARCHAR2                OUT,
    p_groups                       VARCHAR2                OUT,
    p_developer_role               VARCHAR2                OUT,
    p_account_expiry               DATE                    OUT,
    p_account_locked               VARCHAR2                OUT,
    p_change_password_on_first_use VARCHAR2                OUT,
    p_first_password_use_occurred  VARCHAR2                OUT);

Parameters

Table: Fetch_User Parameters Signature 3 describes the parameters available in the FETCH_USER procedure.

Fetch_User Parameters Signature 3

Parameter	Description
`p_user_id`	Numeric primary key of the user account
`p_workspace`	The name of the workspace
`p_user_name`	Alphanumeric name used for login
`p_first_name`	Informational
`p_last_name`	Informational
`p_web_password`	Obfuscated account password
`p_email_address`	Email address
`p_start_date`	Unused
`p_end_date`	Unused
`p_employee_id`	Unused
`p_allow_access_to_schemas`	A list of schemas assigned to the user's workspace to which user is restricted
`p_person_type`	Unused
`p_default_schema`	A database schema assigned to the user's workspace, used by default for browsing
`p_groups`	List of groups of which user is a member
`p_developer_role`	Unused
`p_description`	Informational
`p_account_expiry`	Date account password was last reset
`p_account_locked`	Locked/Unlocked indicator `Y` or `N`
`p_failed_access_attempts`	Counter for consecutive login failures
`p_change_password_on_first_use`	Setting to force password change on first use `Y` or `N`
`p_first_password_use_occurred`	Indicates whether login with password occurred `Y` or `N`