You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
roman:bin$ ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'c';
SQL> create generator g;
SQL> create user u password 'p';
SQL> connect 'c' user 'u' password 'p';
Commit current transaction (y/n)?y
Committing.
Database: 'c', User: U
SQL> select gen_id(g, 1) from rdb$database;
Statement failed, SQLSTATE = 28000
no permission for USAGE access to GENERATOR G
SQL> grant usage on generator g to u;
SQL> select gen_id(g, 1) from rdb$database;
Statement failed, SQLSTATE = 28000
no permission for USAGE access to GENERATOR G
SQL> connect 'c' user 'u' password 'p';
Commit current transaction (y/n)?y
Committing.
Database: 'c', User: U
SQL> select gen_id(g, 1) from rdb$database;
Submitted by: @romansimakov
roman:bin$ ./isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'c';
SQL> create generator g;
SQL> create user u password 'p';
SQL> connect 'c' user 'u' password 'p';
Commit current transaction (y/n)?y
Committing.
Database: 'c', User: U
SQL> select gen_id(g, 1) from rdb$database;
Statement failed, SQLSTATE = 28000
no permission for USAGE access to GENERATOR G
SQL> grant usage on generator g to u;
SQL> select gen_id(g, 1) from rdb$database;
Statement failed, SQLSTATE = 28000
no permission for USAGE access to GENERATOR G
SQL> connect 'c' user 'u' password 'p';
Commit current transaction (y/n)?y
Committing.
Database: 'c', User: U
SQL> select gen_id(g, 1) from rdb$database;
=====================
1
SQL>
Commits: b1ad3c8 578a83a
The text was updated successfully, but these errors were encountered: