| Business small commercial app using Apex [message #592126] |
Sat, 03 August 2013 13:11  |
 |
anil001
Messages: 17
Registered: August 2013
Location: United States
|
Junior Member |
|
|
I am trying to build a small commercial app and wondering how do I implement multi-tenant so that logged in user can see their own enterprise data only.
There will be few tables which will have common data which will be shared among tenants.
Appreciate if you could share any example etc.
|
|
|
|
|
|
| Re: Business small commercial app using Apex [message #592130 is a reply to message #592126] |
Sat, 03 August 2013 14:25  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Here's how I did that. I'll try to simplify it, providing only key information so that you'd get the idea. Real application is somewhat different, but the principle is the same. I also modified table and column names; I tried to pay attention and keep it consistent.
Suppose there are several departments, each of them having unique code, such asSQL> select * from dept;
ID_DEPT NAME_DEPT
---------- ----------------------
400500 London
400501 Rome
400502 Oslo
I also have a table of users, such asSQL> select * from emp;
ID_EMP NAME_EMP
---------- --------------------
4005246 Tiger Scott
4005160 Lion Mike
SQL>
Finally, there's the third table that "joins" users and departments they are allowed to work with:SQL> select * from dept_emp;
ID_EMP ID_DEPT
---------- ----------
4005160 400502
4005246 400500
4005246 400501
4005246 400502
SQL>
That much about the database part of the job.
Within the application, I used the same (part of the) WHERE clause, everywhere, to make sure that every user sees only his own data, such asselect ...
from evid e
where ...
and e.id_dept in (select id_dept from dept_emp
where id_emp = :P0_ID_EMP
)
That's all, more or less.
|
|
|
|
| Re: Business small commercial app using Apex [message #592132 is a reply to message #592126] |
Sat, 03 August 2013 15:24 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
anil001 wrote on Sat, 03 August 2013 19:11I am trying to build a small commercial app and wondering how do I implement multi-tenant so that logged in user can see their own enterprise data only.
There will be few tables which will have common data which will be shared among tenants.
Appreciate if you could share any example etc. If this is a "small commercial app" you probably want to avoid multitenant. The multitenant option costs US$17500 per CPU, on top of US$47500 per CPU for Enterprise Edition licences. Better to stay with views or programmatic techniques, which you can use with a XE licence (which is free).
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
