API user - Intergraph Smart Materials - Version 10.2 - Help - Hexagon

Intergraph Smart Materials Classic Help

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

A database user who has the appropriate rights to connect to the Smart Materials database and access the database objects must be available. For this purpose, you can use M_SYS.

As an alternative, create a user for this particular purpose. The following script shows an example of how to create the API_user. The API_user is created as an Oracle database user with the minimum requirements to use the available Documents API commands.

CREATE USER API_user IDENTIFIED BY manager DEFAULT TABLESPACE MARIAN

TEMPORARY TABLESPACE M_TEMP

/

GRANT CONNECT TO API_user

/

GRANT RESOURCE TO API_user

/

ALTER USER API_user DEFAULT ROLE ALL

/

GRANT EXECUTE ON mpck_login TO API_user

/

GRANT SELECT ON m_projects TO API_user

/

GRANT SELECT ON m_project_product_disciplines TO API_user

/

GRANT EXECUTE ON m_pck_m TO API_user

/

GRANT EXECUTE ON m_api_doc TO API_user

/

GRANT EXECUTE ON m_pck_int_custom TO API_user

/

GRANT SELECT ON m_product_groups TO API_user

/

GRANT SELECT, UPDATE, DELETE, INSERT ON m_doc_imports TO API_user

/

GRANT SELECT, UPDATE, DELETE, INSERT ON mvp_doc_imports TO API_user

/

Each project must have exactly one record with the Use for APIs box selected on the A.20.06.02 User Securities for Projects screen.

This record is used to set the login environment when executing the SET_LOGIN_ENV procedure.