Insufficient permissions error

basement_addict · Post by **basement_addict** » Mon Feb 11, 2008 4:14 pm

In SYSTABLES I have this table

browsetreeimages T browsetreeimages 04 PUBLIC

On one of the servers I get this error:

SQL 1>select * from browsetreeimages;
000 Insufficient permissions on browsetreeimages in the function ipreparetree

here is the file system listing

-rw------- 1 ccast ccast 56640 Feb 11 11:56 browsetreeimages.tbl
-rw------- 1 ccast ccast 57554 Feb 11 11:56 xbrowsetreeimages_browsetreeid.btr
-rw------- 1 ccast ccast 57554 Feb 11 11:56 xunbrowsetreeimages_brwstrmgd.btr

This works fine on several servers but others cause the error.

Post by **John** » Mon Feb 11, 2008 4:41 pm

How does SYSPERMS compare between the servers where it works and where it doesn't?