Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

More information about table what belongs to column when checking privileges [CORE1234] #1658

Closed
firebird-issue-importer opened this issue Apr 27, 2007 · 9 comments

Comments

@firebird-issue-importer

Submitted by: Chernyak Sergey (chernyak.s)

Is related to QA261

Votes: 3

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.

Commits: ec5979c

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 10, 2008

Commented by: Vincent Kwinsey (vincent_kwinsey)

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.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 10, 2008

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 14, 2008

Commented by: @AlexPeshkoff

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>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 14, 2008

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

Workflow: jira [ 11961 ] => Firebird [ 15120 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 13, 2010

Modified by: @dyemanov

Fix Version: 2.1.4 [ 10361 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 13, 2010

Modified by: @dyemanov

summary: More information about table what beelongs to column when checks privileges. => More information about table what belongs to column when checking privileges

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 23, 2011

Modified by: @pcisar

Link: This issue is related to QA261 [ QA261 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2016

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants