RE: user can still connect after CONNECT privilege get revoked
Won't U1 be able to connect as long as he has RESOURCE (R)?
-----Original Message-----
From: owner-informix-list@iiug.org
[mailto:owner-informix-list@iiug.org]On Behalf Of lanegroups@go.com
Sent: Saturday, June 18, 2005 7:12 PM
To: informix-list@iiug.org
Subject: Re: user can still connect after CONNECT privilege get revoked
CONNECT is revoked from PUBLIC as well:
U2 issed the following:
revoke CONNECT FROM U1;
REVOKE CONNECT FROM PUBLIC ;
U1 can still connect after that.
SELECT * FROM informix.sysusers;
username usertype priority password
-------------------------------- -------- -------- ----------------
informix D 9
U1 R 5
U2 D 5
Does the usertype for U1 has problem or anything else missing?
Thanks.
sending to informix-list