-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 
Author Message
 Post subject: Data Level Security Practices in Hibernate ?
PostPosted: Fri Mar 12, 2004 2:27 am 
Beginner
Beginner

Joined: Tue Feb 17, 2004 7:53 am
Posts: 24
Has anyone come across any best practices for data-level security in Hibernate? Any source of information, links etc ?


Top
 Profile  
 
 Post subject: Re: Data Level Security Practices in Hibernate ?
PostPosted: Fri Mar 12, 2004 3:42 am 
CGLIB Developer
CGLIB Developer

Joined: Thu Aug 28, 2003 1:44 pm
Posts: 1217
Location: Vilnius, Lithuania
anjali wrote:
Has anyone come across any best practices for data-level security in Hibernate? Any source of information, links etc ?


The best practice for security reasons is not to have security in Hibernate :)

Application level security for data is the same as application level data validation, it is more UI helper than security.
If you need security then use native data base security or use stored procedures/triggers to implement custom security.
Mapping will be more complicated, you will need to use views for all tables and "RULE"/"INSTEAD OF TRIGGER" to "hide" procedures. It takes a lot of to time to design this kind of database, but you must pay this if you need quality and security.


Top
 Profile  
 
 Post subject:
PostPosted: Thu May 06, 2004 10:09 am 
Beginner
Beginner

Joined: Mon Feb 23, 2004 1:17 pm
Posts: 28
This is impossible if you desgn your application to be database independant (including for example MySQl which has no trigger nor view support). If you write your complete update/save/security strategy in the database you will never be able to easily portrable to a different platform. So there is a definate use/need for security in the Hibernate level.

Save / update / delete security can be built using interceptors and or validators by implementing Validatable.


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 07, 2004 12:33 pm 
CGLIB Developer
CGLIB Developer

Joined: Thu Aug 28, 2003 1:44 pm
Posts: 1217
Location: Vilnius, Lithuania
ToAoM wrote:
This is impossible if you desgn your application to be database independant (including for example MySQl which has no trigger nor view support). If you write your complete update/save/security strategy in the database you will never be able to easily portrable to a different platform. So there is a definate use/need for security in the Hibernate level.

Save / update / delete security can be built using interceptors and or validators by implementing Validatable.


Is it some meaning to design application this way ? If application works on mySQL then there is no meaning to buy database for this app and to pay for unused features.


Top
 Profile  
 
 Post subject:
PostPosted: Fri May 07, 2004 5:16 pm 
Beginner
Beginner

Joined: Mon Feb 23, 2004 1:17 pm
Posts: 28
But if you design an application that is to e deployed on client machines on which an oracle installation is running and no MySQL can be installed by company policy there is not much of a choice is there?


Top
 Profile  
 
 Post subject:
PostPosted: Sat May 08, 2004 2:21 am 
CGLIB Developer
CGLIB Developer

Joined: Thu Aug 28, 2003 1:44 pm
Posts: 1217
Location: Vilnius, Lithuania
Use embeded database for this kind of applications like Cloudscape or Pointbase.


Top
 Profile  
 
 Post subject:
PostPosted: Sat May 08, 2004 5:42 am 
Beginner
Beginner

Joined: Mon Feb 23, 2004 1:17 pm
Posts: 28
Those don't scale well in larger applications and don't offer replication, automated backups and can't be maintained by existing DBA's at the client. No, Hibernate was built to be database independent and we use this feature whenever possible.


Top
 Profile  
 
 Post subject:
PostPosted: Sat May 08, 2004 6:21 am 
CGLIB Developer
CGLIB Developer

Joined: Thu Aug 28, 2003 1:44 pm
Posts: 1217
Location: Vilnius, Lithuania
Quote:
Those don't scale well in larger applications and don't offer replication, automated backups and can't be maintained by existing DBA's at the client.
So it means you need real database, not mySQL. Is it so hard to understand ?


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.