Re: problem with Informix users management. PLEAAASE HELP !

Look for set session authorization in the sql syntax manual. "Ph. Chantry" <nospam@nomail.co To: informix-list@iiug.org m> cc: Sent by: Subject: Re: problem with Informix users management. PLEAAASE owner-informix-li HELP ! st@iiug.org 01/23/2004 09:40 AM Please respond to "Ph. Chantry" "Chewbacca" <yapas@nullepart.com> a 'crit dans le message de news:bur89f$28s$1@s1.read.news.oleane.net... > IDS 7.23 TC 14 on Windows NT system. > > On an old Db, i had "public" as DBA. I revoked it get make a better user > management but when i try to revoke all privileges to any table from public, > the system accepts it and when i look at the list of privileges of the > table, public always has his privileges (insert , update...) > I have done ressources revoking for public, but nothing better > > please help me, i'm blocked with problem. > Thanx for your help ! Are you the owner of the tables ? Maybe another user has granted some privileges to "public" ? Look in the systabauth table who is the grantor of the privileges. ------------------------------------------------------------------------ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. sending to informix-list