Create Users - 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

To create a new user, enter all mandatory values. You can edit the values for the optional columns (Mandatory=No) later on the A.20.05 Users screen.

If you select the Global Access indicator (super_user_ind) for a new user, this new user will automatically get access to all product groups and projects for all disciplines. All disciplines will be assigned as queryable disciplines and all privileges will be granted to the user. Further, the SUPER USER role will be assigned to the user; this role grants access to all Smart Materials modules, screens, functions, and data.

The arguments of the CREATE_USER function are listed below.

Argument Name

Type

In/Out

P_USER

Record, user_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 m_users.m_usr_id.

The following table shows the values that can be transferred with P_USER in the CREATE_USER function.

Column Name

Mandatory

Description

user_id

Yes

Username (VARCHAR2(10), m_users.m_usr_id)

password

Yes

User Password (VARCHAR2(500), plain password)

ugr_code

Yes

User Group (VARCHAR2(10), m_user_groups.ugr_code)

first_name

Yes

First Name (VARCHAR2(30), m_users.first_name)

last_name

Yes

Last Name (VARCHAR2(40), m_users.last_name)

company

Yes

Company Name (VARCHAR2(60), m_users.company)

department

Yes

Department Name (VARCHAR2(20), m_users.department)

telephone

Yes

Telephone (VARCHAR2(40), m_users.telephone)

fax

No

Fax (VARCHAR2(40), m_users.fax)

email

No

Email Address (VARCHAR2(50), m_users.email)

pw_change_days

No

Password Change Interval (NUMBER(6), m_users.pw_change_days)

pw_history

No

Password History Size (NUMBER(6), m_users.pw_history)

complex_pw_enforced

No

Complex Password? (VARCHAR2(1), m_users.complex_pw_enforced)

super_user_ind

No

Global Access (VARCHAR2(1), m_users.super_user_ind)

mail_password

No

Password via Email (VARCHAR2(1), default ‘N’)

amount

No

Allowed Amount (NUMBER(24), m_users.amount)

currency

No

Currency (VARCHAR2(10), m_units.unit_code)