Hi,
I am thinking of developing a web application that uses a database
underneath to hold most of its application data. However, to make it more
"secure", I would like the application to log on to the database with the
same user/schema that logs into the web application -- automatically. I.e.
each application user should have its own private area (user/schema) in the
database, minimizing the risk that you by accident fetch or update data for
another user than the one logged in originally.
How do I make all database access done in my app work this way (and
transparent too) -- can't really see how to do it with standard
configuration of datasources and jdbc resource pools...
I use Glassfish V2 and Netbeans as my development environment.
This feels a bit like a SSO thing but I'm not that keen on trying to
implement a full-blown SSO solution when it's just one single database
resource involved.
Does anyone have any experience of this and how to achieve this fast and
simple?
Thanks in advance,
/roland.
--
View this message in context: http://www.nabble.com/Different-login-user---different-database-schema-tp19389692p19389692.html
Sent from the java.net - glassfish users mailing list archive at Nabble.com.