syssqlstat from users

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lossanchez - 27 Oct 2006 16:16 GMT

Hello:
Now in version 10.FC5, the users can't execute 'select ' from table
syssqlstat. In other version it's posible execute this select , but in
10 version only informix user can execute it.
There is a environ varible for another users ??
It's Onconfig configuration??

Reply to this Message

scottishpoet - 27 Oct 2006 22:45 GMT

> Hello:
> Now in version 10.FC5, the users can't execute 'select ' from table
> syssqlstat. In other version it's posible execute this select , but in
> 10 version only informix user can execute it.
> There is a environ varible for another users ??
> It's Onconfig configuration??

Is this the first time you have tried 10 after upgrading from 7 or an
early IDS 9?

Have you see this article?

http://www-1.ibm.com/support/docview.wss?rs=0&context=SSGU5D&context=SSHMMC&cont
ext=SSGU8G&context=SSGKNY&context=SSGU5Y&context=SSCRW7&context=SSGHZP&context=S
SVT2J&q1=unsecure+onstat&uid=swg21208876&loc=en_GB&cs=utf-8&lang=

There are security issues associated with letting any user see the SQL
other users are running. The information in this article may help
resolve your problem

Reply to this Message