FETCH_USER Procedure

This procedure fetches a user account record. To execute this procedure, the current user must have administrative privileges in the workspace.

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);

Parameters

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

Fetch_User Parameters

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_description`	Informational
`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`	Unused
`p_developer_role`	Unused