Multitenant shared user account?

Posted by jpartogi on Stack Overflow See other posts from Stack Overflow or by jpartogi
Published on 2010-05-20T08:55:19Z Indexed on 2010/05/20 9:00 UTC
Read the original article Hit count: 287

Filed under:

multi-tenant

|

ruby-on-rails

|

mysql

Dear all,

Based on your experience, which is the route to go for a multi-tenant user login?

One user login per account. Which means if there is one user that has access to multiple account, there will be redundancy of record in the database
One user login for all account that she has privileges to. Which means one user record has access to multiple account if she has privileges to that account.

From your experience, which one is better and why? I was thinking to choose the latter, but I don't know whether it will cause security issue or less flexibility.

Thank you for sharing your experience.

© Stack Overflow or respective owner

Related posts about multi-tenant

How to configure Multi-tenant plugin as single-tenant with Spring security plugin as resolver?

as seen on Stack Overflow - Search for 'Stack Overflow'
I can create a secure, multi-tenant web app with Grails by : setup spring security plugin, setup Multi-tenant plugin (via multi-tenant install and multi-tenant-spring-security) update config.groovy : tenant { mode = "multiTenant" resolver.type = "springSecurity" } add : Integer userTenntId… >>> More
How to Test a Multi-Tenant App with support for multiple domains

as seen on Stack Overflow - Search for 'Stack Overflow'
HI, we are building a multi-tenant application, which will support that each tenant can have a unique top level domain, the application is build using the asp.net 3.5 and SQL servr 2005, while each tenant will have different database. I have seen a number of questions about the similar applications… >>> More
Introduction to Multi-Tenant Architecture

as seen on Internet.com - Search for 'Internet.com'
Learn how to create websites with similar functionality yet different UIs and maintain them across one shared code base using Multi-Tenant Website Architecture. >>> More
???????????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle Database 12c??????”???????”????????????????????????????????????????????Oracle Database 12c????????·?????????????????? (EnterpriseZine/DB Online)???????Oracle Database 12c R1????VI? ???????·??????? (?????) ??????????????????????????????????????????????????????????Wiley??”Dummies… >>> More
EC2 hosted service multi-tenant dynamic DNS solution

as seen on Server Fault - Search for 'Server Fault'
I want to change the model of my EC2 hosted service to have a separate sub domain for each tenant (ie. .example.com). My primary DNS is now with dnsmadeeasy.com, but their dynamic DNS offering seem pretty weak: it requires the API to use my full dnsmadeeasy.com account credentials, I rather have… >>> More

Related posts about ruby-on-rails

Ruby on Rails - How can I start? [closed]

as seen on Programmers - Search for 'Programmers'
I have misconception in understanding the relationship between Ruby language and Ruby on Rails Framework. Because of 'I am an absolute beginner' in web development I have no idea if I have to grasp the fundamentals of Ruby before I go with Ruby on Rails! I also want to ask who is behind both Ruby… >>> More
DES3 decryption in Ruby on Rails

as seen on Stack Overflow - Search for 'Stack Overflow'
My RoR server receives a string, that was encrypted in C++ application using des3 with base64 encoding The cipher object is created so: cipher = OpenSSL::Cipher::Cipher::new("des3") cipher.key = key_str cipher.iv = iv_str key_str and iv_str: are string representations of key and initialization… >>> More
Ruby on rails: Image downloads with Authentication/Authorization/Time outs

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys, I'm having few doubts on implementing file downloads. I'm creating an app where I use attachment_fu with Amazon s3 to upload files. Things are working pretty well so far on uploading side. Now its the time to start the file downloads. Here is what I need, a logged in user search and browse… >>> More
Ruby on Rails deployment, on "thin" server with lot of attachments

as seen on Stack Overflow - Search for 'Stack Overflow'
A lot of PDFs are stored inside MySQL as a BLOB field for each PDF file. The average file size is 500K each. The Rails app will stream the :binary data as file downloads, where there is a user click on the download link. Assume there is a maximum of 5 users downloading 5 PDFs concurrently, what… >>> More
Apply Behavior Driven Development to Ruby on Rails with Rspec

as seen on Internet.com - Search for 'Internet.com'
Applying the Behavior Driven Development (BDD) methodology to your Rails development takes you beyond traditional Test Driven Development. Learn how to do it with the Ruby-based BDD framework RSpec. >>> More