Online Documentation for SQL Manager for InterBase/Firebird

Embedded User Editor

The Embedded User Editor dialog window allows you to view/edit embedded users.

 

To open an embedded user in Embedded User Editor, double-click it in the DB Explorer tree.

 

User

This page allows you to specify embedded user name, password, personal info, default role and specific settings for the embedded user being created/edited.

 

 

 

Name

Enter a name for the new embedded user, or view the name of the embedded user being edited.

Note: Embedded user name is significant to 31 characters and is not case sensitive.

 

Password / Confirm password

Set a password by which the embedded user will be identified in the database.

Note: Password is significant to 8 characters and is case sensitive.

 

First name / Middle name / Last name

Specify embedded user's real name (as opposed to login name): first name, middle name, last name.

 

Default role

Use the drop-down list to select the role the embedded user being created/edited will have privileges of (by default).

 

System user name

Enter the name of the system user.

 

Group name

Enter the name of the group the embedded user will belong to.

 

GID

Optional GroupID. Currently not used by InterBase.

 

UID

Optional UserID. Currently not used by InterBase.

 

Active

This option activates/deactivates the embedded user.

 

Database Owner

If this option is selected, the embedded user is the database owner (rdb$user_privilege = 1).

 

 

Roles

This page allows you to select the role the embedded user being created/edited will have privileges of.

 

 

To select a role, you need to move it from the Available Roles list to the Selected Roles list. Use the  buttons or drag-and-drop operations to move the objects from one list to another.

 

---