Does anybody knows Informix Security very well ?

[rostik]

Hi,
Does anybody know how to remove a user from PUBLIC group in informix Security? The problem is, that when I am creating user acount on Unix box, this acount becomes to be a leageble user for Informix DB. I cannot (some business rules) REVOKE all from PUBLIC. What I need is just to remove an user account from PUBLIC group.

Thanks in advance.
Rostik
Chicago

 

[richman]

Rostik,

If this user should no longer have access to the database use the following;

revoke connect from 'user';

If you want something else give more detail.
Happy New Year -
Rich