Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsMultitenant Shared Data
https://www.eclipse.org/forums/index.php/mv/msg/235340/716183/#msg_716183
However I've run across a scenario where I need to implement a concept of an audit user that has read only access to all records within a limited number of tables / entities and their corresponding relationship entities. I'm not sure how exactly to accomplish this.
From what I can understand adding multiple tenant discriminator columns just creates more permutations of the same record (i.e. entity A belongs to company 123 and has a role of manager).
I am using container managed EJB's to manage entity operations ( persist, query / find, merge).
Is there a way to either:
1. Inject a persistencecontext that defines very specific entities within the persistence unit but can query against all tenants (override multi tenancy).
2. Provide multiple tenants to query against?
As a heads up I do not have the capability to generate materialized query tables or any secondary views.
I also intend to audit the heck out of any operation of this sort and lock down this access.
Thanks in advance!
]]>Jonathan 2011-08-16T15:56:57-00:00Re: Multitenant Shared Data
https://www.eclipse.org/forums/index.php/mv/msg/235340/725371/#msg_725371
Right now the only way you could achieve this is through another persistence-unit definition (which removed the multitenancy)
Feel free to vote for the following EclipseLink bug 355458 in the mean time.
Also, if you are familiar with VPD on Oracle (if using Oracle DB) you could potentially use it to provide the admin functionality. ]]>Guy Pelletier2011-09-14T15:44:43-00:00(no subject)
https://www.eclipse.org/forums/index.php/mv/msg/235340/725380/#msg_725380
Right now the only way you could achieve this is through another persistence-unit definition (which removed the multitenancy)
Feel free to vote for the following EclipseLink bug 355458 in the mean time.
Also, if you are familiar with VPD on Oracle (if using Oracle DB) you could potentially use it to provide the admin functionality.]]>Guy Pelletier2011-09-14T15:44:44-00:00Re: (no subject)
https://www.eclipse.org/forums/index.php/mv/msg/235340/726209/#msg_726209
Jonathan 2011-09-16T20:03:03-00:00Re: (no subject)
https://www.eclipse.org/forums/index.php/mv/msg/235340/726214/#msg_726214
Jonathan2011-09-16T20:03:04-00:00Re: (no subject)
https://www.eclipse.org/forums/index.php/mv/msg/235340/726217/#msg_726217
Jonathan2011-09-16T20:03:04-00:00Re: Multitenant Shared Data
https://www.eclipse.org/forums/index.php/mv/msg/235340/895590/#msg_895590
How do you set entity mapping for EMF per tenant?