Oracle E-Business Suite Interface Connector > FAQ > FAQ
  

FAQ

How to create a new user in the database?
A new user gets the access to read all the base tables or views, and write to all the interface tables in a .ini file.
Perform the following steps to create a new user in the database:
  1. 1. Connect to the database as sysdba.
  2. 2. Create a user name in the <username> format and set a password in the <password> format.
  3. 3. Grant session to the user.
How to grant different privileges to a user?
  1. 1. Connect to the database as sysdba.
  2. 2. Enter the following to grant different privileges to a user:
  3. GRANT SELECT ON [Schema].[Table] TO [User}
    GRANT INSERT ON [Schema].[Table] TO [User]
How to configure the .ini file with parameters?
A user must specify the list of interface tables and programs associated to the .ini file.
  1. 1. Open the Application Developer.
  2. 2. Navigate to Concurrent > Program.
  3. The following image shows the Concurrent Program page:
  4. 3. Specify the value of the Program field.
  5. 4. Under the Executable session, specify the value of the Name field.
  6. 5. Click Parameters.
  7. The following image shows the Parameters page:
  8. 6. Enter the values of the Parameter fields for the .ini files.
How to set the MORG ID parameter?
We can set the MORG ID parameter in two ways: