Newsgroups: comp.databases
Path: utzoo!utgpu!watserv1!watmath!att!cbnewsd!aec
From: aec@cbnewsd.att.com (arthur.e.cooper)
Subject: Allowing Users To Access Database From Another File System
Organization: AT&T Bell Laboratories
Distribution: na
Date: Tue, 6 Nov 90 22:22:56 GMT
Message-ID: <1990Nov6.222256.541@cbnewsd.att.com>
Keywords: INFORMIX, GRANT CONNECT, GRANT ALL PRIVILEGES
Lines: 29


This may be a trivial question, but it has me baffeled.

I've created a database and want to permit access from another file
system (on the same machine). The grant connect statement, in this
case, allows a user from the other file system to interact with the 
database tables to produce reports but not get into the mode to add 
records, query, or update.

This is the problem:

A typical user would logon to the given file system. A command in
the .profile executes a UNIX shell (run program) on the file system
that will directly access the database and its programs. The run
program sets the environment and executes another shell that displays
the main menu and prompts for input. 
After selecting, from the menu, the item that will call the function
sperform which executes the form specification file, the system prints
an X on the next line, there is a pause, the screen is cleared and the
menu is displayed again. What we should see at this point is the first
screen. This problem only exist when attempting indirect access.
I've used both grant all privileges and grant connect (with appropriate
revokes between the two) but the results remain the same.
If anyone would care to offer suggestions or possible solutions I'd
certainly appreciate the help.
-- 


    Art Cooper    AT&T Bell Laboratories    att!ihlpl!wd9aet   708-979-3049