Adding a User to the Security Database Using the Services API

From InterBase
Jump to: navigation, search

You can create a new user in the InterBase security database using the cluster identifier isc_action_svc_add_user. The first argument in the cluster must be isc_spb_sec_username. The following table lists arguments to this cluster:

Services API arguments for isc_action_svc_add_user
Argument Purpose Argument length Argument value

isc_spb_sec_username

User name to create; maximum 31 characters; mandatory argument, must be the first parameter

2 byte length + string

String

isc_spb_sec_password

Password for the user; maximum 31 characters, only first 8 characters are significant; mandatory argument

2 byte length + string

String

isc_spb_sec_firstname

Optional first name of the person using this user name

2 byte length + string

String

isc_spb_sec_middlename

Optional middle name of the person using this user name

2 byte length + string

String

isc_spb_sec_lastname

Optional last name of the person using this user name

2 byte length + string

String

isc_spb_sec_userid

Optional user ID number, defined in /etc/passwd, to assign to the user; reserved for future implementation

4 bytes

Unsigned long

isc_spb_sec_groupid

Optional group ID number, defined in /etc/group, to assign to the user; reserved for future implementation

4 bytes

Unsigned long

isc_spb_sec_groupname

Optional group name, as defined in /etc/group, to assign to the user; reserved for future implementation

2 byte length + string

String

isc_spb_sql_role_name

Optional SQL role to adopt when administering users (reserved for future use)

2 byte length + string

String