Skip to main content

Grant access privileges to accounts tutorials

The tutorials in this section allow you to grant an account rights to an integration table.

Create a user account

  1. Open a command prompt in the tools subfolder of the <faircom> installation folder.

  2. Paste the following command into the command line: sa_admin -aADMIN -pADMIN -sFAIRCOMS -oua user1 -w password1

  3. Change user1 to your desired username.

  4. Change password1 to your desired password.

  5. Run the command.

Grant rights to an integration table

Prerequisites:

  1. Create a user account.

  2. Access API Explorer.

Warning

Do NOT grant alter or delete rights, because integration tables must only be created and deleted through API actions such as "createIntegrationTable" and "deleteIntegrationTable".

  1. Click the SQL Scripts tab (SQL Scripts Tab).

  2. Paste the following script into the textbox to allow the specified user to read (select) and insert records into the specified table.

    Tip

    To only grant read rights, only grant the select right.

    grant select on admin.table1 to user1;
grant insert on admin.table1 to user1;
commit;

    • Change table1 to a new integration table name of your choice.

    • Change user1 to a username of your choice.

    Caution

    Use this sample grant update command only if you want to allow an account to modify collected data.

    grant update on admin.table1 to user1;

  3. Click Run All (Run All).

  4. Repeat Step 1 through Step 3 to grant rights to any additional integration tables.