Re: ISQL/DBACCESS - User Priviliges
David Lapsley wrote:
>
> We have an Informix (online 7.2) server with 3 databases.
>
> How do I ensure that one of the databases can ONLY be accessed from a 4gl
> application, yet have the other 2 databases reasonably open allowing access
> from ISQL/DBACCESS.
You can't restrict access based on the tool used. Access is based on
userid, but take a look at roles. You could setup a 4GL role and switch
to it in 4GL programs only. Just remember that if a user can switch to
a role in 4GL then they can also do so in dbaccess. ;-)
The other alternative would to use stored procedures to access the
database from 4GL. If the parameters required by these procedures were
cryptic enough, no one would dream of calling them from dbaccess.
Hope that helps,
--
Mark.
+------------------------------------------------------------------+
|Mark D. Stock - The West Solutions Group http://www.west.co.za |
| The Informix FAQ is at http://www.iiug.org |
|mailto:marks@west.co.za +-----------------------------------------+
|Tel: +27 11 803 2151 |If it doesn't work, force it! |
|Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!|
|Cell: +27 83 250 2325 |Well, that's how I code anyway! |
+------------------------+-----------------------------------------+