create_user_firebird_3.sql

CREATE OR ALTER USER FB_ADMIN PASSWORD 'fb_admin' GRANT ADMIN ROLE;

EXECUTE BLOCK
AS
  DECLARE VARIABLE tablename VARCHAR(32);
BEGIN
  FOR SELECT rdb$relation_name
  FROM rdb$relations
  WHERE rdb$view_blr IS NULL
  AND (rdb$system_flag IS NULL OR rdb$system_flag = 0)
  INTO :tablename DO
  BEGIN
    EXECUTE STATEMENT ('GRANT ALL ON TABLE ' || :tablename || ' TO USER FB_ADMIN WITH GRANT OPTION');
  END
END