Path: utzoo!utgpu!jarvis.csri.toronto.edu!rutgers!cs.utexas.edu!uunet!zephyr!tektronix!sequent!sandramc
From: sandramc@sequent.UUCP (Sandra McMaster)
Newsgroups: comp.databases
Subject: Re: Informix Isql Protection
Keywords: user-menu
Message-ID: <18261@sequent.UUCP>
Date: 4 Jul 89 07:34:39 GMT
References: <4266@uhccux.uhcc.hawaii.edu>
Reply-To: sandramc@crg4.UUCP (Sandra McMaster)
Organization: Sequent Computer Systems, Inc
Lines: 35

In article <4266@uhccux.uhcc.hawaii.edu> richardj@uhccux.UUCP (Richard Jablonka) writes:
>Howzit,
>
>  I am using Informix Isql on the unix for the first time. I have made a 
>  database which lists grades for students in a class. Students are Rows in all
>  tables in the database.  How do I limit access to just the row where the
>  the logged-in student's record is?  I don't want student to access other
>  student records.   
> 
>                                        Thanks,
>                                        Richard Jablonka


Off hand, I can think of a couple solutions that might work...

1) you could create views for each of your students... not the cleanest
   solution but it would work
2) using Informix 4GL (for a screen oriented solution) or ACE report
   writer (for a report oriented solution) you could do a query
   using the user's login name so that they only get info that is
   tied to their name [this would also require putting the students'
   login names in the database] -- the variable USER should give
   you the login name

If you want to mail me a listing of your database schema, I would
be happy to assist you in writing the necessary query...  

One other thought... you need to make sure that your database
is not accessible to "public"... if it is, anyone logging into
the system could potentially gain access to the database if they
can get access to the directory where you have the database stored...
(check the permissions under Database, Table, Permissions.... you 
use the SQL to change permissions - the grant and revoke commands)

Hope this helps... :-)