Joel,
I just went through the Sequoia documentation and I have one question
regarding database user management.
If I want to set-up a Sequoia infrastructure (architecture with two collocated
controller with two DB each for full replication between controllers) and I
want to use different database users to execute different actions (one for
insert, one for select...).
Can I configure this in Sequoia? How?
Sequoia will proxy your client connections. So if you connect as user
Tom, Sequoia will in turn connect to the database using the real login
associated to the virtual user Tom.
If you want Tom to execute the SELECT and Joel to execute the INSERT.
Your application must connect as Tom when it executes SELECT statements
and connect as Joel when it executes INSERT.
In Sequoia, it is possible to remap client application users (called
virtual logins) to different physical database accounts (called real
logins). However, it will not be possible to map different queries from
the same user to different physical accounts.
I hope this answers your question. Let us know more about your use case
if a new feature would be needed in Sequoia to support your requirements.
Thanks for your feedback,
Emmanuel
--
Emmanuel Cecchet
Chief Scientific Officer, Continuent
Blog: http://emanux.blogspot.com/
Open source: http://www.continuent.org
Corporate: http://www.continuent.com
Skype: emmanuel_cecchet
Cell: +33 687 342 685
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
