On 04/03/12 12:19, Thomas Steinmaurer wrote:
>
> Have you had a look on how InterBase handles encryption (p. 207ff.)?
> http://docs.embarcadero.com/products/interbase/IBXEUpdate3/DataDef.pdf
>
> In InterBase it is AFAIK pure SQL 

Yes, is see.

> and what also seems to be useful is 
> separating duties as there seems to be a special user SYSDSO. 

That's absolutely unrelated with encryption. But must say that we do
plan to provide not special users, but predefined roles (you may treat
it as further development of RDB$ADMIN role) for performing special
tasks inhibited in other case. For example user granted something like
RDB$BACKUP role will be able to backup database not being DBA.

> As far as 
> I can see, encryption in InterBase is only possible when Embedded User 
> Authentication is used. 

Strange limitation.

> I have two questions on Firebird encryption?
>
> - I guess this all is transparent to the client?
> - Is a backup, either via gbak or nbackup of an encrypted database 
> automatically encrypted as well?

Please read thread 'Database encryption' (there are 2 articles only) in
architect before discussing that issues.


------------------------------------------------------------------------------
Better than sec? Nothing is better than sec when it comes to
monitoring Big Data applications. Try Boundary one-second 
resolution app monitoring today. Free.
http://p.sf.net/sfu/Boundary-dev2dev
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to