FirebirdSQL logo

Who Can Create a User

To create a user account, the current user must have

  • administrator privileges in the security database

  • the USER_MANAGEMENT system privilege in the security database.Users with the USER_MANAGEMENT system privilege can not grant or revoke the admin role.

CREATE USER Examples

  1. Creating a user with the username bigshot:

    CREATE USER bigshot PASSWORD 'buckshot';
  2. Creating a user with the Legacy_UserManager user manager plugin

    CREATE USER godzilla PASSWORD 'robot'
      USING PLUGIN Legacy_UserManager;
  3. Creating the user john with custom attributes:

    CREATE USER john PASSWORD 'fYe_3Ksw'
      FIRSTNAME 'John' LASTNAME 'Doe'
      TAGS (BIRTHYEAR='1970', CITY='New York');
  4. Creating an inactive user:

    CREATE USER john PASSWORD 'fYe_3Ksw'
      INACTIVE;
  5. Creating the user superuser with user management privileges:

    CREATE USER superuser PASSWORD 'kMn8Kjh'
    GRANT ADMIN ROLE;