Create User Securities - Intergraph Smart Materials - Version 2020 (10.0) - Administration & Configuration - Hexagon PPM

Intergraph Smart Materials Classic Administration (2020)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Administration & Configuration
Smart Materials/Smart Reference Data Version
2020 (10.0)

When creating new user securities, you can copy user privileges and/or queryable disciplines from another user.

To create a new user security record, enter all mandatory values. To copy user privileges, set copy_user_privs to Y and define the data for cp_user_privs. To copy queryable disciplines, set copy_qry_dp to Y and define the data for cp_qry_dp.

The arguments of the CREATE_US function are listed below.

Argument Name

Type

In/Out

P_US

Record, us_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 CREATE_US function.

Column Name

Mandatory

Description

pg_proj

Yes

PJ (Project) or PG (Product Group) (VARCHAR2(2), default 'PJ')

pg_code

Yes

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

proj_id

Yes

Project (VARCHAR2(10), m_projects.proj_id)

user_id

Yes

Username (VARCHAR2(10), m_users.m_usr_id)

dp_code

Yes

Discipline (VARCHAR2(10), m_disciplines.dp_code)

nls_id

Yes

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

aktiv

Yes

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

role_name

Yes

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

list_view

Yes

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

sec_code

Yes

Section (VARCHAR2(10), m_sections.sec_code)

api_ind

Yes

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

copy_user_privs

No

(VARCHAR2(1), default N)

cp_user_privs

No

us_copy_data_rec

copy_qry_dp

No

(VARCHAR2(1), default N)

cp_qry_dp

No

us_copy_data_rec

The values needed for US_COPY_DATA_REC are listed below. These values must be provided for cp_user_privs if copy_user_privs is set to Y, or for cp_qry_dp if copy_qry_dp is set to Y.

Column Name

Mandatory

Description

user_id

Yes

Username (VARCHAR2(10), m_users.m_usr_id)

pg_code

Yes

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

proj_id

Yes

Project (VARCHAR2(10), m_projects.proj_id)

dp_code

Yes

Discipline (VARCHAR2(10), m_disciplines.dp_code)

nls_id

Yes

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

role_name

Yes

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