Re: Partitioning tables with grouping
Posted by:
Rick James
Date: April 13, 2010 11:40PM
If the clients are sharing nothing, consider creating a database per client. That will probably provide better security. You can easily dump a database. And (if you let them login directly) you can GRANT access to only their own database.
If there are more than a few thousand clients, this approach may get unwieldy.
Create the database names yourself. If not, be sure to sanitize and dedup the database names.
Subject
Views
Written By
Posted
2970
April 10, 2010 07:31AM
1756
April 11, 2010 10:41PM
2441
April 11, 2010 11:00PM
Re: Partitioning tables with grouping
1831
April 13, 2010 11:40PM
1953
April 14, 2010 05:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.