Re: RE: user cannot select systables

Originally posted by Murray Wood \\ > 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"]mailto:owner-i- > nformix-list@iiug.orgOn 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/http://dbforums.com > > sending to informix-list -- Posted via http://dbforums.com