Another Permissions question
Posted in 2005
So I've been experimenting to try and understand Informix permissions. Looking at the sysuser table, there are 3 entries. One of those three is "public". Is "public" a special user? Do users that connect to Informix but don't exist in the sysuser table get the "public" permissions? I ask this, because if I connect as a user that exists on the server but not within Informix, I seem to have full privileges to select, create, update, delete anything I want. I want to understand how best to lock things down a little bit. It would be nice to prevent everybody from being able to connect and view the HR/Payroll data for instance -- or to alter their scholastic records, etc. How do others manage database permissions? Brian McLaughlin Administrative Computing George Fox University (503) 554-2587 sending to informix-list