RE: user cannot select systables

Sounds like you have not given that user connect permission to that database. In (dbaccess) that database "grant connect to his_user_id;" Otherwise run dbschema -d database -p all and look at the permissions. MW > > -----Original Message----- > > From: owner-informix-list@iiug.org > > [mailto:owner-informix-list@iiug.org]On Behalf Of mike.guice > > Sent: Friday, 27 June 2003 7:13 a.m. > > To: informix-list@iiug.org > > Subject: user cannot select systables > > > > > > > > All, > > > > I'm new to Informix but not new to databases. I have a user > who cannot > > select from the systables in their own database. > > > > As user informix (the big daddy rabbit), I have no problem. > > > > If I change the "connection" in dbaccess (CONNECTION: Connect > > Disconnect > > Exit) with informix's login, and pick the same shared memory segment > > that the database in question resides in, the user can select > > systables. > > > > I'm fairly sure that this has something to do with access to shared > > memory segments but I can't find any info on it. > > > > I have granted all kinds of roles (more than I should) just > > to get this > > to work and to no avail. > > > > What permissions do I need to grant (if that's the problem) ? > > > > BTW - This user has no problem doing this type of activity in a > > development environment. This is holding up an application > > upgrade (eek). > > > > Thanks Ahead! > > > > Mike Guice > > > > -- > > Posted via http://dbforums.com > sending to informix-list