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