Issue Details (XML | Word | Printable)

Key: CORE-1377
Type: New Feature New Feature
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Alexander Peshkov
Reporter: Dave Albiston
Votes: 0
Watchers: 2

If you were logged in you would be able to see more operations.
Firebird Core

Add an ability to change role without reconnecting to database.

Created: 24/Jul/07 11:19 AM   Updated: 12/May/16 11:22 AM
Component/s: API / Client Library
Affects Version/s: 2.1 Beta 1
Fix Version/s: 3.0 Beta 1

Environment: Any
Issue Links:

QA Status: Done successfully

 Description  « Hide
It would be useful if an application could connect to the database and then set the role without disconnecting and re-connecting.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 24/Jul/07 01:31 PM
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.

Alexander Peshkov added a comment - 25/Jul/07 02:49 AM
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.

Roman Simakov added a comment - 25/Jul/07 05:30 AM
May be use all roles granted to the user if one didn't define role by connecting?

Dmitry Yemanov added a comment - 25/Jul/07 06:52 AM
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 :-)

Alexander Peshkov added a comment - 04/Jan/08 01:16 PM
Changed according to previous discussion results.

Alexander Peshkov added a comment - 30/Apr/14 03:12 PM
Implemented SQL 2008 compliant operator
SET ROLE rolename
and FB-specific form
making it possible to access trusted role if it's available.