I have a database with grants commands setted (for admin, user, ..). How can I connect each users with database (according with db rules) in rails? When rails application start it is connected according database.yml.. but I need a right connection based on user type! Thanks!! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I''m not sure I understand the question. Are you talking about authenticating a users connection to the database inside your application? If so that has nothing todo with the rails database connection. You need to lookinto a plugin that will do authentication and authorization on the rails application side... OR You want to lock down the access that you application has to the database? GRANT SELECT,DROP ON app_production.* TO ''someuser''@''somewhere'' IDENTIFIED BY ''somepassword''; That gives someuser connecting from host somwhere SELECT and DROP access to the app_production database with the password somepassword ??? Does that answer your question or am I way off? --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
> Are you talking about authenticating a users connection to the > database inside your application? > > If so that has nothing todo with the rails database connection. You > need to lookinto a plugin that will do authentication and > authorization on the rails application side... > > OR > > You want to lock down the access that you application has to the > database? > > GRANT SELECT,DROP ON app_production.* TO ''someuser''@''somewhere'' > IDENTIFIED BY ''somepassword''; > > That gives someuser connecting from host somwhere SELECT and DROP > access to the app_production database with the password > somepassword ??? > > Does that answer your question or am I way off?I''ve grant commands setted into database (with GRANT SELECT.......), 3 grant (for 3 user types). For ex, if you are connetted to myhost.com/admin, you will be prompted for insert your account information and rails will be connected to database with "admin" user.. nothing more, nothing less ;) . I know that this don''t sound good, but I can''t modify my db.. and db have grants and views.. If there are some trick to avoid this.. Thank you -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Sep 25, 4:27 am, Al Shox <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> > Are you talking about authenticating a users connection to the > > database inside your application? > > > If so that has nothing todo with the rails database connection. You > > need to lookinto a plugin that will do authentication and > > authorization on the rails application side... > > > OR > > > You want to lock down the access that you application has to the > > database? > > > GRANT SELECT,DROP ON app_production.* TO ''someuser''@''somewhere'' > > IDENTIFIED BY ''somepassword''; > > > That gives someuser connecting from host somwhere SELECT and DROP > > access to the app_production database with the password > > somepassword ??? > > > Does that answer your question or am I way off? > > I''ve grant commands setted into database (with GRANT SELECT.......), 3 > grant (for 3 user types). > For ex, if you are connetted to myhost.com/admin, you will be prompted > for insert your account information and rails will be connected to > database with "admin" user.. nothing more, nothing less ;) . > I know that this don''t sound good, but I can''t modify my db.. and db > have grants and views.. > If there are some trick to avoid this.. > > Thank you > -- > Posted viahttp://www.ruby-forum.com/.Something like this? ActiveRecord::Base.establish_connection( :adapter => "mysql", :host => "localhost", :username => "admin", :password => "password", :database => "database" ) --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Erol Fornoles wrote:> On Sep 25, 4:27�am, Al Shox <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote: >> > database? >> I''ve grant commands setted into database (with GRANT SELECT.......), 3 >> Posted viahttp://www.ruby-forum.com/. > Something like this? > > ActiveRecord::Base.establish_connection( > :adapter => "mysql", > :host => "localhost", > :username => "admin", > :password => "password", > :database => "database" > )(I''ve hear about it but..) You think that I need to create a "singleton" class that have "n" instances of database?? It''s the only solution?? Please help me with code samples!! This isn''t a trivial project and I need something concrete, otherwise I need to take another language solutions.. and I really don''t want!! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Sep 25, 8:03 am, Al Shox <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Erol Fornoles wrote: > > On Sep 25, 4:27 am, Al Shox <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote: > >> > database? > >> I''ve grant commands setted into database (with GRANT SELECT.......), 3 > >> Posted viahttp://www.ruby-forum.com/. > > Something like this? > > > ActiveRecord::Base.establish_connection( > > :adapter => "mysql", > > :host => "localhost", > > :username => "admin", > > :password => "password", > > :database => "database" > > ) > > (I''ve hear about it but..) > You think that I need to create a "singleton" class that have "n" > instances of database?? It''s the only solution?? > > Please help me with code samples!! This isn''t a trivial project and I > need something concrete, otherwise I need to take another language > solutions.. and I really don''t want!! > -- > Posted viahttp://www.ruby-forum.com/.Not necessarily. How many kinds of db user accounts do you have? Are they fixed, or do you have a variable number of them? --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Erol Fornoles wrote:> On Sep 25, 8:03�am, Al Shox <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote: >> > � :username => "admin", >> solutions.. and I really don''t want!! >> -- >> Posted viahttp://www.ruby-forum.com/. > > Not necessarily. How many kinds of db user accounts do you have? Are > they fixed, or do you have a variable number of them?Three db accounts, and they are fixed. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Sep 25, 6:08 pm, Al Shox <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Three db accounts, and they are fixed. > -- > Posted viahttp://www.ruby-forum.com/.You might want to try Dr. Nic''s Magic Multi-Connections to make the job easier. http://magicmodels.rubyforge.org/magic_multi_connections/ --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
> You might want to try Dr. Nic''s Magic Multi-Connections to make the > job easier.Nice name anyway ;)> http://magicmodels.rubyforge.org/magic_multi_connections/I''ll going to see.. Thanks! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---