RE: Views and Tables

From: Chris Stephens <ChrisStephens_at_affina.com>
Date: Tue, 9 Mar 2004 15:29:45 -0600
Message-ID: <4A82CFCF30FDD211A7960008C7B19170236968E6@hero.affina.net>

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

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 - 15:27:13 CST