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-issue-importer opened this issue Jul 24, 2007 · 13 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 24, 2007

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 25, 2007

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 25, 2007

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 25, 2007

Commented by: @romansimakov

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jul 25, 2007

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 4, 2008

Commented by: @AlexPeshkoff

Changed according to previous discussion results.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 4, 2008

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 30, 2014

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-issue-importer
Copy link
Author

firebird-issue-importer commented Apr 30, 2014

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 28, 2015

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Sep 28, 2015

Modified by: @pcisar

Link: This issue is related to QA626 [ QA626 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 12, 2016

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