Path: utzoo!attcan!uunet!ginosko!rex!ames!uhccux!richardj
From: richardj@uhccux.uhcc.hawaii.edu (Richard Jablonka)
Newsgroups: comp.databases
Subject: Informix isql Protection
Keywords: grant, select
Message-ID: <4457@uhccux.uhcc.hawaii.edu>
Date: 30 Jul 89 02:56:19 GMT
Reply-To: richardj@uhccux.UUCP (Richard Jablonka)
Organization: University of Hawaii
Lines: 9


I am designing a database using Informix isql and don't understand how the 
protection works.  I have created 2 tables and 2 corresponding views ( 1
for each table).  The tables have records of all students, the views show the
record for just the student concerned.  Here's the question:

I know that I have to give SELECT rights to each table, in order to allow
user to use  each view.  How do I stop users from just logging into isql 
quering the tables directly?