> Dear all,
> If blocking SYSDBA from connecting the database is the goal, than ones can
> create a role with the name SYSDBA.Is there any minus about this?
AFAIR, this needs to be done with a direct system table insertion in RDB$ROLES
with 2.5 and earlier. I don't know if this has changed in
Dear all,
If blocking SYSDBA from connecting the database is the goal, than ones can
create a role with the name SYSDBA.Is there any minus about this?
Regards,Tjioe
Hi,
> Dear all,
> Though I don't have the same question as Roland, information below by Virna
> Constantin (costel...@yahoo.com) is very useful.Thanks every one.
> Regards,Tjioe
>
> Suggestion
> event studies "on connect"
> 1. an application with minimum rights connects to the database
> 1 '. in
Dear all,
Though I don't have the same question as Roland, information below by Virna
Constantin (costel...@yahoo.com) is very useful.Thanks every one.
Regards,Tjioe
Suggestion
event studies "on connect"
1. an application with minimum rights connects to the database
1 '. in table
08.04.2016 11:32, Elmar Haneke el...@haneke.de [firebird-support] wrote:
> You can use database encryption for that purpose
No. Encryption can protect "cold" database on HDD in garbage collector, for
example,
but not an active one.
--
WBR, SD.
> How can I prevent that my database can be opened with another
> security.fdb.
You can use database encryption for that purpose - without knowing the
encryption key there is no way to access database.
In FB3 there is a new plugin mechanism for encryption added you should
have a look ath that.
08.04.2016 10:12, 'Mueller, Roland (GE87)' roland.muel...@honeywell.com
[firebird-support]
wrote:
> Is there any way to prevent this and only use our authentication ?
No.
--
WBR, SD.
Thanks for your suggestions.
I am actually searching for another way. This database is part of an
application that is deployed at our customers.
In the new firebird release it is possible to choose security authentication
via external .fbd file or programmed into the database itself.
We want
Suggestion
event studies "on connect"
1. an application with minimum rights connects to the database
1 '. in table "mon$attachmnts" field "MON$REMOTE_PROCESS" will record the
application name
2. in the trigger event "on connect" if the user connects SysAdmin, verifies
the application name in
I would suggest that the best way to prevent anyone getting hold of your
database and opening it with a separate security database is to have good
security & physical protection on your server, limited access to the server
room (if appropriate) and so on. Normal security precautions in other
Hi all
How can I prevent that my database can be opened with another security.fdb.
For testing we use firebird 3.
We use our database as its own security database.
If we copy our database to another Firebird installation it
is possible to open it with sysdba and masterkey.
Is there a way to
12 matches
Mail list logo