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

Add an ability to change role without reconnecting to database. [CORE1377] #1795

Closed
firebird-automations opened this issue Jul 24, 2007 · 13 comments

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

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.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: @romansimakov

May be use all roles granted to the user if one didn't define role by connecting?

@firebird-automations
Copy link
Collaborator Author

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 :-)

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Changed according to previous discussion results.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

description: 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.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 12672 ] => Firebird [ 14245 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Implemented SQL 2008 compliant operator
SET ROLE rolename
and FB-specific form
SET TRUSTED ROLE
making it possible to access trusted role if it's available.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA626 [ QA626 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE2088 [ CORE2088 ]

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