Re: [firebird-support] Understanding Firebird Security

2019-05-20 Thread sbai...@mutualconsultants.ltd.uk [firebird-support]
Dimitry, > You cannot do that if you > 1) Have no access to the file (and server file system as whole). > 2) Don't know password of database owner. 1) Yes agreed, you need access to the file - so I have been testing what happens if the file does somehow fall into the wrong hands 2) In

Re: [firebird-support] Understanding Firebird Security

2019-05-20 Thread sbai...@mutualconsultants.ltd.uk [firebird-support]
Alexey, thank you for the extremenly quick response. So, I did understand correctly - anyone can open any Firebird database and view the data (unless it happens to be encrypted). I am rather shocked by that. Steve Bailey

[firebird-support] Understanding Firebird Security

2019-05-20 Thread sbai...@mutualconsultants.ltd.uk [firebird-support]
I am new to Firebird, trying to understand how it handles user security. I want to create a database owned by and accessible to only one user - and that should not be SYSDBA. Let's call the database MyDB. In databases.conf I created an alias for MyDB and specified that it should be

Re: [firebird-support] Firebird 4 and RDB$ERROR

2019-05-16 Thread sbai...@mutualconsultants.ltd.uk [firebird-support]
Helen, Thanks for the prompt reply. You wrote: "So - off-topic in Firebird Support. But, anyway..." Apologies for that. I did not read the welcome email (which says no questions on alpha or beta releases) until after I had posted my question (assuming Firebird Support was the right

[firebird-support] Firebird 4 and RDB$ERROR

2019-05-15 Thread sbai...@mutualconsultants.ltd.uk [firebird-support]
I am using Firebird 4.0 Beta 1. The release notes describe a new system function RDB$ERROR: "The function RDB$ERROR() takes a PSQL error context as input and returns the specific context of the active exception. Its scope is confined to the context of the exception-handling block in PSQL.