Issue Details (XML | Word | Printable)

Key: CORE-1234
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Chernyak Sergey
Votes: 3
Watchers: 0
Operations

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

More information about table what belongs to column when checking privileges

Created: 27/Apr/07 11:37 AM   Updated: 23/Feb/11 10:26 AM
Component/s: Security
Affects Version/s: 2.0.0, 2.0.1
Fix Version/s: 2.5 Alpha 1, 2.1.4

Time Tracking:
Not Specified

Environment: All systems
Issue Links:
Relate
 


 Description  « Hide
When user have privileges on some columns on table (not on all) and try to update other columns (not have privileges), server rises exception "This user does not have privilege to perform this operation on this object. no permission for update/write access on COLUMN <SOME_NAME>".
It is good to know TABLE which this COLUMN belongs.

something like this
"...no permission for update/write access on COLUMN <SOME_NAME> in TABLE <TABLE_NAME>".

Sorry for my English.

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vincent Kwinsey added a comment - 10/Jan/08 05:16 AM
As fas as I know - then Interbase reported only table name, but since around FB 1.5.3 the reporting of column name (only) was introduced as 'error reporting improvement'. From column name it is always possible to retrive all the tables (from rdb$relation_fields) which have columns with some name, but there can be a lot of tables for some popular column name as 'description' or 'amount' - the present form of error message is really confusing and sometime almost without any value.

Alexander Peshkov added a comment - 14/Jan/08 03:24 AM
Improved diagnostics - now once can see:
SQL> update table2 set c2=0;
Statement failed, SQLCODE = -551
no permission for update/write access to COLUMN TABLE2.C2
SQL>