Re: controlled access

}Date: Thu, 30 Sep 1993 12:38:11 +0100 (MET) }From: Verschraegen Luc <Luc.Verschraegen@rug.ac.be> }Subject: controlled access }X-Informix-List-Id: <list.2883> } }We want to set up an environment which gives access to one OnLine }server system by means of the DBaccess tool. } }There are two distinct groups of students: } } group 1: Has a connect privilege to an existing database. } Members of this group may not create databases. } } group 2: Must be able to create databases, but only in a predefined DB space } }Until now I have not found a way to impose these rules. }Environment : Sun SPARC with SunOS 4.1.3, OnLine 5.00.UC4 Neither of these restrictions can be implemented. Group 2 is marginally the easier of the two to handle -- use a separate OnLine instance which therefore only allows them to create databases where you want them. But if the know which tbconfig file to use, they can still play with the other OnLine instances (by setting TBCONFIG), so it is by no means a complete solution. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>