Issue Details (XML | Word | Printable)

Key: CORE-5747
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Roman Simakov
Reporter: Roman Simakov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

User can grant usage privilege by himself

Created: 12/Feb/18 02:35 PM   Updated: 24/Sep/18 10:34 AM
Component/s: Engine
Affects Version/s: 3.0.3
Fix Version/s: 3.0.4, 4.0 Beta 1

Environment: Ubuntu x86_64, SS

QA Status: Done successfully


 Description  « Hide
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;

               GEN_ID
=====================
                    1

SQL>


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.