Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

fc_create_user( )

Creates a new FairCom DB SQL user username with initial password pass.

The username is a user ID that is limited to a 32-byte ASCIIZ string (a null-terminated ASCII string), which implies 31 bytes are available for the User ID.

The ID is limited to alphanumeric characters, hyphens, underscores, and periods. A hyphen character (-) cannot be used as the first character.

The server ignores the case of the ASCII characters. Therefore, the server considers TEST_1.FairCom-4 to be the same as test_1.faircom-4.

When RBAC is active, fc_create_user() is replace by fc_create_account().

Parameters (2)

username VARCHAR(32)

pass VARCHAR(32)

Example

call fc_create_user('accounting', 'unbreakable');

TOCIndex