In the case of an Oracle database for Smart 3D, the user who connects from Smart Reference Data during the bulkload needs to be known in the Smart 3D database also. In our example, it will be the SPRDINT user performing the bulkload; thus, this user must be created in the Smart 3D database.
The Smart 3D user must be set as a domain user account for an Oracle database, not a local user account.
Open a SQL*Plus session and connect as sys to the Smart 3D database. Then perform the commands below to create the user and grant the needed rights.
create user sprdint identified externally;
grant connect, sp3duser, sp3d_project_administrators to sprdint;
To enable user authentication by the operating system, use the command below. The Smart Reference Data user can then connect to the Smart 3D database located on a remote host.
alter system set remote_os_authent=true scope=spfile;
After, restart the database instance to apply the changed spfile.