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
Add an ability to change role without reconnecting to database. [CORE1377] #1795
Comments
Commented by: @dyemanov I think this feature request has nothing to do with the authentication type. What you seem to need is an ability to change the role at runtime (being already connected to the database). The SQL specification declares such a feature. |
Modified by: @AlexPeshkoffassignee: Alexander Peshkov [ alexpeshkoff ] |
Commented by: @AlexPeshkoff Some other database servers use not roles, but groups, and as soon as user is a member of that group, it's granted all rights, assigned to that group, w/o need to mention that group connecting to database. This is not required, but in many cases makes life slightly easier. What about adding something like AUTO keyword when granting role to user? Such role can be automagically used when no other is given. |
Commented by: @romansimakov May be use all roles granted to the user if one didn't define role by connecting? |
Commented by: @dyemanov The SQL specification clearly defines how roles should work. So, if we want something different, let's invent groups as an alternative feature. We already have such a feature request in the tracker, IIRC :-) |
Commented by: @AlexPeshkoff Changed according to previous discussion results. |
Modified by: @AlexPeshkoffdescription: It would be useful if an application could connect to the database with Windows authentication, query the role assigned to the user and then set the role without disconnecting and re-connecting. => It would be useful if an application could connect to the database and then set the role without disconnecting and re-connecting. summary: Extension of Windows Authentication => Add an ability to change role without reconnecting to database. |
Modified by: @pcisarWorkflow: jira [ 12672 ] => Firebird [ 14245 ] |
Commented by: @AlexPeshkoff Implemented SQL 2008 compliant operator |
Modified by: @AlexPeshkoffstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Beta 1 [ 10332 ] |
Submitted by: Dave Albiston (dalbiston)
Is related to QA626
Is duplicated by CORE2088
It would be useful if an application could connect to the database and then set the role without disconnecting and re-connecting.
Commits: 9bd0939 FirebirdSQL/fbt-repository@2efbe24
The text was updated successfully, but these errors were encountered: