Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
10
Newest
 Commentator
Impact
~1k people reached

Mar
2
comment How to handle db authentication in multi tenant application with separate databases?
@JeffO, Oh! Thanks for your help. This question would be opinionated question on StackOverflow, but it should be fine here. I am asking about what approach in programming is good for such cases.
Mar
2
comment How to handle db authentication in multi tenant application with separate databases?
So you mean, database based username restriction on the database? Something like GRANT ALL ON tenantdb1.* TO 'tenant1'@'localhost';
Feb
28
comment How to handle db authentication in multi tenant application with separate databases?
I am not sure if this applies on what I am trying to do. Storing redirection details on a shared database and then authenticating it against its own db is fine but the connection used will have access to all tenant database then which is what I am trying to restrict.
Feb
28
awarded  Commentator
Feb
28
comment How to handle db authentication in multi tenant application with separate databases?
@JeffO, Is this comment towards me? I don't follow
Feb
26
comment How to handle db authentication in multi tenant application with separate databases?
@DocBrown, I have added some details specific to your comments.
Feb
26
revised How to handle db authentication in multi tenant application with separate databases?
added 99 characters in body
Feb
26
comment How to handle db authentication in multi tenant application with separate databases?
@DocBrown, I totally agree that there is no best solution, but I have to know what I need to consider on what scenario, which I don't to be honest. So any suggestions are welcome.
Feb
26
comment How to handle db authentication in multi tenant application with separate databases?
@RobbieDee, They don't essentially need to separate, but the plan is to go with separated databases for options like backup/restore, database corruption. e.t.c
Feb
26
comment Should I use one database per application or share a single database amongst multiple applications
What would you suggest is this case?
Feb
26
asked How to handle db authentication in multi tenant application with separate databases?
Sep
17
comment What approach in DataMapper Pattern is better for multiple or joined tables?
Thanks. My only concern was that different tables although related to one another could have their individual Mapper maintaining them. If another mapper does a part of this because the data is related, then the logic of maintaining or abstracting the data of the related is separated among two mappers. This is what feels like "This could be done in better way" kinda feeling inside.
Sep
10
revised What approach in DataMapper Pattern is better for multiple or joined tables?
added 157 characters in body
Sep
10
asked What approach in DataMapper Pattern is better for multiple or joined tables?
May
20
revised Why are shortcuts like x += y considered good practice?
typo
Feb
26
awarded  Caucus
Oct
12
awarded  Critic
Oct
12
comment What is the proper way to create a cross-fade effect?
Well, Thanks for the extra information. But not quite What I am looking for.
Oct
12
awarded  Quorum
Oct
12
revised What is the proper way to create a cross-fade effect?
added 23 characters in body