Hi to everybody, my name is Alfredo Rico from Venezuela. Please apologize if my english is not so good...
My company is beginning a huge enterprise rails project for a goverment customer. We have setting up a postgresql database following a number of considerations that make it a fortress, implementing a lot of bussines rules requiriments from our goverment customer. I'm talking about an integration database and not about an application database. Hence a legacy system. The database contains a number of features among which we could mention the following: - A lot of store procedures and triggers. - Reporting based on views. - High granularity database user roles. - Data integrity constraints. The matter is the following: There are a lot of database users which belongs to different kind of databases roles according to their responsibilities, and when a new user is incorporated from the web application, actually that new user is added to the database system users (I meant, there isn't a database table called Users but the users belongs to postgresql). What a hell!!!.. Why??? :-) Because we are modeling a database for the future. Today is rails (and for several years I meant). Tomorow we won't know. Besides, another applications (probably developed on differents programming languages) will use our postgres database. The shoot: We would like to develop an elegant and efficient ActiveRecord solution that let us the following: When an application user like the beautiful assistant accounting department, set her username and password to login on the web form, the authentication process must be performed on a successfully database establishment connection. Cause her username and password belong to a postgresql database user. I suspect that probably we'll need a kind of special configuration for a database connection pool which should not degrade our application's performance. Could you give me some suggestions? Thanks a lot. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
