Xref: alice comp.databases.oracle.server:44176
Path: alice!news-feed.fnsi.net!news.idt.net!newshub.northeast.verio.net!europa.clark.net!209.44.33.119!hub1.ispnews.com!news12.ispnews.com.POSTED!not-for-mail
Message-ID: <36FA83D7.636B@vm-advies.nl>
From: Martijn Oudeman <m.a.oudeman@vm-advies.nl>
Reply-To: m.a.oudeman@vm-advies.nl
Organization: Vellekoop & Meesters bv
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Autorisation in ODBC for Oracle 7.3
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 14
X-Trace: news12.ispnews.com 922387590 194.151.12.152 (Thu, 25 Mar 1999 13:46:30 EST)
NNTP-Posting-Date: Thu, 25 Mar 1999 13:46:30 EST
Date: Thu, 25 Mar 1999 19:43:35 +0100

I am a user of a ODBC driver fro a Oracle 7.3 database. I use the driver
in combination with Excel. I have to wuestions?

1.
Is it possible within ODBC to disable insert, update and delete
priveleges for a certain user. The user does have these priveleges while
user the original application for which the database was build.

2. 
Is it possible to incorporate horizontal database autorisation through
ODBC without using VIEWS on the original tables? 
If not, how can I manage that a certain user can only read data from a
database when the retreived records meet certain conditions (derived
from the user name of other database tables) ?