<< Managing Firebird and InterBase users | IBEBlock | ibec_AlterUser >>

ibec_CreateUser

Syntax

 ibec_CreateUser(ConnectOptions, UserData : string) : variant;

All functions return NULL if there were no errors, otherwise they return an error message text.

ConnectOptions is a list of parameters to connect to the Services Manager delimited by semicolons. Possible options are:

Server=<server_name>The name of the server. Also you can use ServerName=<server_name> to specify the server name.
Protocol=<protocol>The network protocol with which to connect to the server. Possible values are 'Local', 'TCP', 'SPX' and 'NamedPipe'.
User=<user_name>The user name.
Password=<password>The password.
ClientLib=<client_lib_name>The name of client library dll, by default GDS32.DLL.

Example

        ibec_DropUser('Server=localhost; User=SYSDBA; Password=masterkey;
                         Protocol=TCP; ClientLib=gds32.dll', 'VASYA');

If the server name is not specified the connection will be established with the local server using the local protocol. TCP/IP will be used when the server name is specified but the protocol is not specified.

UserData is a list of user properties, delimited by semicolons. Possible properties are:

UserName=<user_name>User name to create or modify; maximum 31 characters.
Password=<password>Password for the user; maximum 31 characters, only the first 8 characters are significant.
FirstName=<first_name>Optional first name of the person using this user name.
MiddleName=<middle_name>Optional middle name of the person using this user name.
LastName=<last_name>Optional last name of the person using this user name.
UserID=<user_id>Optional userID number, defined in /etc/passwd, to assign to the user; reserved for future implementation.
GroupID=<group_id>Optional groupID number, defined in /etc/group, to assign to the user; reserved for future implementation.

Example

        ibec_CreateUser('Server=localhost; User=SYSDBA; Password=masterkey;
                           Protocol=TCP',
                        'UserName=BILL_GATES; Password=microsoft; FirstName=BILL;
                           LastName=GATES');

back to top of page
<< Managing Firebird and InterBase users | IBEBlock | ibec_AlterUser >>