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