On Tue, Sep 14, 2010 at 8:30 AM, Ritesh Nadhani <riteshn@stripped> wrote:
> On Mon, Sep 13, 2010 at 11:29 PM, Johan De Meersman <vegivamp@stripped>
> wrote:
> > Well, traditionally, partitioning :-)
> >
> > Bandwidth, storage, ... ?
> >
>
> Well, without getting into much details, it mostly about security.
>
Unless you're worried about the actual DBAs, I see no issue in granting a
user select only on a single partition instead of the global table. Don't
forget, a "partitioned table'" is just a layer, and the partitions are
actual, real tables that may be queried directly.
If you *are* worried about your DBAs, you have bigger problems than
partitioning :-)
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel