Update User Securities - Intergraph Smart Materials - Version 10.2 - Administration & Configuration - Hexagon

Intergraph Smart Materials Classic Administration (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Materials/Smart Reference Data Version
10.2

The arguments of the UPDATE_US function are listed below.

Argument Name

Type

In/Out

P_US

Record, us_upd_rec

IN

P_PROJ_ID

VARCHAR2(10), m_projects.proj_id

IN

P_COMMIT

VARCHAR2

IN

P_RESULT

NUMBER

OUT

P_MESSAGE

VARCHAR2

OUT

The function returns the m_user_securities.us_id.

The following table shows the values that can be transferred with P_US in the UPDATE_US function.

Column Name

Mandatory

Description

us_id

Yes

User Security Identifier (NUMBER(12), m_user_securities.us_id)

pg_code

No

Product Group (VARCHAR2(10), m_product_groups.pg_code)

proj_id

No

Project (VARCHAR2(10), m_projects.proj_id)

user_id

No

Username (VARCHAR2(10), m_users.m_usr_id)

dp_code

No

Discipline (VARCHAR2(10), m_disciplines.dp_code)

nls_id

No

Language Identifier (NUMBER(2), m_nls.nls_id)

aktiv

No

Active (VARCHAR2(3), m_user_securities.aktiv, default 'ON')

role_name

No

Role Name (VARCHAR2(20), m_appl_roles.role_name)

list_view

No

List View (VARCHAR2(10), m_list_views.lv_code)

sec_code

No

Section (VARCHAR2(10), m_sections.sec_code)

api_ind

No

Use for APIs (VARCHAR2(1), m_user_securities.api_ind)