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

Use of RDB$ADMIN role does not provide SYSDBA rights in GRANT/REVOKE [CORE2765] #3157

Closed
firebird-automations opened this issue Nov 22, 2009 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @AlexPeshkoff

#⁠ ./isql employee
Database: employee
SQL> grant "RDB$ADMIN" to alex;

With role RDB$ADMIN I get message from the system trigger:

#⁠ ./isql -user alex -pas alex employee -role 'rdb$admin'
Database: employee, User: alex, Role: RDB$ADMIN
SQL> select * from a; -- user alex has no explicit / public grants on table A, i.e. for select it works
SQL> grant all on a to man1;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-STORE RDB$USER_PRIVILEGES failed in grant
-action cancelled by trigger (2) to preserve data integrity
-user does not have GRANT privileges for operation

Without role RDB$ADMIN I get expected message:

#⁠ ./isql -user alex -pas alex employee
Database: employee, User: alex
SQL> grant all on a to man1;
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-no S privilege with grant option on table/view A

Commits: 3606706 386ad2c

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 2.5 Beta 2 [ 10300 ]

Version: 2.5 Beta 1 [ 10251 ]

Version: 2.5 Alpha 1 [ 10224 ]

Version: 2.5 RC1 [ 10362 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Component: Engine [ 10000 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 RC2 [ 10372 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment