let FB3 can have security database specified in the connection string
---------------------------------------------------------------------
Key: CORE-4641
URL: http://tracker.firebirdsql.org/browse/CORE-4641
Project: Firebird Core
Issue Type: Improvement
Affects Versions: 3.0 Beta 1
Reporter: Arioch
FB3 comes with an option (in aliases.conf and in DPB) to override the default
security database per connection.
It would be very usable feature for packaged software, which considers FB
databases a kind of a document, user is free to File|Open
Currently a packaged software cannot manage FB users without risks that it
would interfere with some another software possibly using the same instance of
FB (usually the only one in OS).
However, legacy software development tools/libraries would hardly support that
new DPB parameter on their own, especially the generic libraries trying to
provide uniform class API for any of the supported servers. Example:
Embarcadero DBExpress.
Proposal: extend the connection string in FB3 with optional parameter
specifying the security database to be used, so that vendors (or in some
scenarios even system administrators on the end user site) could easily
overcome the limitations of the libraries/development tools.
https://www.connectionstrings.com/firebird/
Let FB clients (fbclient.dll, Jaybrid, etc) recognize an optional parameter
"SecurityDB=" which can have the following values:
* "default" - same as if the parameter is omitted
* "self" - same value as in "Database=" parameter
* "external,<alias opr path to FDB file>" - the explicit way to specify SecDB.
The latter variant might be excessive, in practical scenarios perhaps just the
ability to append the CS with ";SecurityDB=self" would be enough, however to
fully represent abilities in aliases.conf it might be supported as well.
Regarding priorities, this parameter is to be considered on the same level, as
DPB, that is:
1: if both the CS and the DPB have specified and non-default Security Database,
then they hould be exactly the same, otherwise the connection attempt fails
2: if one of the CS and the DPB have specified non-default SecDB (and the
counterpart does not specify it or specify as default), then that value is used.
If the connection is made by-alias and the aliases.conf has SecDB specified,
and the CS has specified it too, the behavior is to be the same as if the
latter value came from DPB rather from the CS.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
from Actuate! Instantly Supercharge Your Business Reports and Dashboards
with Interactivity, Sharing, Native Excel Exports, App Integration & more
Get technology previously reserved for billion-dollar corporations, FREE
http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
