Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.