Java DB (Derby Database) queries

[Deepali Pandey <de...@oracle.com>]

Hi , 

 

Can somebody please help with the customer queries below regarding Java DB (Derby Database) that comes bundled with the Oracle Glassfish server. 

1) Does Java DB support database level audit trail ? 
2) Does Java DB support database level encryption ? 

Any pointers will be most helpful. 

 

Regards,

Deepali

 

 

Re: Java DB (Derby Database) queries

[Bryan Pendleton <bp...@gmail.com>]

>> 1) Does Java DB support database level audit trail ?
>>
> Derby does not provide any support for tracking security-related operations.

If you only need to audit update statements, you may be able to
define triggers that do what you need.

Typically this is done by having your triggers append auditing
records to a separate audit table in your database. Then you
can query the audit table later to see what work has been occurring.

thanks,

bryan

Re: Java DB (Derby Database) queries

[Rick Hillegas <ri...@oracle.com>]

Hi Deepali,

Some comments inline...

On 7/25/12 10:02 PM, Deepali Pandey wrote:
>
> Hi ,
>
> Can somebody please help with the customer queries below regarding 
> Java DB (Derby Database) that comes bundled with the Oracle Glassfish 
> server.
>
> 1) Does Java DB support database level audit trail ?
>
Derby does not provide any support for tracking security-related 
operations. You're welcome to log a JIRA to add this kind of 
functionality to Derby.
>
> 2) Does Java DB support database level encryption ?
>
Yes. For more information, see the "Encrypting databases on disk" 
section of the Derby Developer's Guide: 
http://db.apache.org/derby/docs/10.9/devguide/

Hope this helps,
-Rick
>
>
> Any pointers will be most helpful.
>
> Regards,
>
> Deepali
>