Oninit cdi / Archive
Talk to an expert →

problem with Informix users management. PLEAAASE HELP !

Posted in 2004

Topics: Server Administration, Security, Permissions & Auditing, Versions, Editions & End-of-Life

Chewbacca — — source: Usenet: comp.databases.informix

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 !

↪ replying to Chewbacca
Ph. Chantry — — source: Usenet: comp.databases.informix

"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.

Glossary