dbschema strangeness

IDS 11.50 FC8 on HP-UX I get this error when trying to run dbschema -hd on a specific table. A -t is fine, and -hd on other tables seems fine. Just this one. Any ideas? I have so many PMRs open at present I can't bear another one ;-) Thx Neil # dbschema -d <database> -hd <table> DBSCHEMA Schema Utility INFORMIX-SQL Version 11.50.FC8 -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>. -272 - No SELECT permission for <table>.

What are the permissions on the table? Art On Jul 4, 2012 8:23 PM, "NEIL TRUBY" <neil.truby@ardenta.com> wrote: > IDS 11.50 FC8 on HP-UX > > I get this error when trying to run dbschema -hd on a specific table. A -t > is > fine, and -hd on other tables seems fine. Just this one. > > Any ideas? I have so many PMRs open at present I can't bear another one ;-) > > Thx > Neil > > # dbschema -d <database> -hd <table>> > DBSCHEMA Schema Utility INFORMIX-SQL Version 11.50.FC8 > > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > -272 - No SELECT permission for <table>. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --f46d042ef79d8c974e04c40b1329

All revoked. If I grant select on table <table> to informix as <owner> it's OK. Don't really understand it but thanks! N