Accounts tutorials

JSON ADMIN API tutorials for managing accounts

Tutorials on managing accounts using the JSON Admin API and migrating encrypted data files to be V13-compatible with FIPS-140.2 security standards. The tutorials detail encryption changes, FIPS compliance requirements, provider information, compatibility, data migration steps, and backward compatibility options. They also include tutorials on granting access privileges to user accounts for integration tables, emphasizing specific commands and security precautions, particularly against granting alter or delete rights.

accounts API tutorials

account creation tutorial

account management tutorial

how to create account

how to modify account

change account permissions

assign roles to accounts

Faircom DB encryption

FIPS 140.2

encrypted data migration

json admin api

JSON Action tutorials

account management

manage accounts

grant access privileges

ctencrypt

ctcmpcif

change password

change master key

user accounts

data migration tutorial

admin tutorial

how to change passwords

Tutorial: Grant access privileges

Tutorial for granting access privileges to accounts

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

Create a user account

Open a command prompt in the tools subfolder of the <faircom> installation folder.
Paste the following command into the command line, replacing user1 with your desired username and password1 with your desired password:
```
sa_admin -aADMIN -pADMIN -sFAIRCOMS -oua user1 -w password1
```
See the sa_admin utility for more options.
Run the command.

Grant rights to an integration table

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".

Click the SQL Scripts tab ().
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;
```
Click Run All ().
Repeat Step 1 through Step 3 to grant rights to any additional integration tables.