Troubleshooting
Problem
VA test fail with the following error:
Error No connect permission. Assessment Test: 'INFORMIX Authority granted to PUBLIC'
select count(*) from informix.sysusers where lower(username) = 'public';
2021-05-27 14:20:09 Error No connect permission. Assessment Test: 'INFORMIX Columns granted to PUBLIC in user databases'
select count(*) from informix.systables t, informix.syscolumns c, informix.syscolauth a where t.tabid = c.tabid and c.tabid = a.tabid and c.colno = a.colno and a.grantee = 'public' and t.tabid > 99;
2021-05-27 14:20:09 Error No connect permission. Assessment Test: 'INFORMIX Restrict DBA Authority'
select count(*) from informix.sysusers where usertype = 'D' and lower(username) not in ('informix','root') and username not in (select owner from sysmaster:informix.sysdatabases where name = DBINFO('dbname'));
Error No connect permission. Assessment Test: 'INFORMIX Authority granted to PUBLIC'
select count(*) from informix.sysusers where lower(username) = 'public';
2021-05-27 14:20:09 Error No connect permission. Assessment Test: 'INFORMIX Columns granted to PUBLIC in user databases'
select count(*) from informix.systables t, informix.syscolumns c, informix.syscolauth a where t.tabid = c.tabid and c.tabid = a.tabid and c.colno = a.colno and a.grantee = 'public' and t.tabid > 99;
2021-05-27 14:20:09 Error No connect permission. Assessment Test: 'INFORMIX Restrict DBA Authority'
select count(*) from informix.sysusers where usertype = 'D' and lower(username) not in ('informix','root') and username not in (select owner from sysmaster:informix.sysdatabases where name = DBINFO('dbname'));
Symptom
Vulnerability Assessment (VA) Tests for Informix failing with error "No connect permission"
Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"ARM Category":[{"code":"a8m0z000000Gp0RAAS","label":"VULNERABILITY ASSESSMENT"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
10 September 2021
UID
ibm16465511