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