| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Views and Tables
I'll have to check it out.
Fortunately all partitions use the same naming convention. They are working on January data, so the partition is name_200401, etc.
The view can set the date, so that queries won't go over multiple partitions.
Views would allow them to work on the partitions, but not make them available until they are done.
Some partitions are over 200 million rows.
If there is only one criteria for "readers", views alone might be enough.
They are supposed to do some requirements planning.
This department is usually working the data so hard, fast and furious that they don't get much time to do much "extra".
They have been so happy I've come along.
Michael Alan Kline, Sr.
www.b2bsol.com
804-744-1545
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
Behalf Of Chris Stephens
Sent: Tuesday, March 09, 2004 4:45 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: Views and Tables
Maybe...but wouldn't you get the added benefit of partition elimination....and you wouldn't have to worry about any security flaws you might not have thought (none in mind).
Chris
-----Original Message-----
From: Stephane Faroult [mailto:sfaroult_at_oriole.com]
Sent: Tuesday, March 09, 2004 3:36 PM
To: oracle-l_at_freelists.org
Subject: Re: Views and Tables
That's using a power hammer to prepare powder sugar. The initial mistake is to create the views not under the reporting user, but the schema owner - and GRANT SELECT on the views, and the views only, to the reporting user.
SF
Chris Stephens wrote:
>
> Have you looked into row level security?
>
> ...i think that would be ideal and easy to implement.
>
> Chris
>
> -----Original Message-----
> From: mkline1_at_comcast.net [mailto:mkline1_at_comcast.net]
> Sent: Tuesday, March 09, 2004 3:18 PM
> To: oracle-l_at_freelists.org
> Subject: Views and Tables
>
> Client has quite a few partitioned tables. Users are starting to want to
> query the actual tables, but we've got to keep them from queries that
might
> combine multiple partitions.
>
> We can probably create some "this_month", "last_month" views under a
> reporting user id, but if the views can select the tables, then if the
user
> is cleaver enough, they too may find they can get to the tables.
>
> Is there a way to let them see the views but hide the table names from
them?
>
> I figure one of the table views will give it all away.
>
> We do monitor with Precise, but still.
>
> This is 8.1.7.4 on HP-UX.
>
> --
> Michael Kline
> B2Bsol
> Midlothian, VA 23112
> 804-744-1545
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Tue Mar 09 2004 - 17:58:44 CST
 |
 |