Page 1 of 1

Insufficient permissions error

Posted: Mon Feb 11, 2008 4:14 pm
by basement_addict
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.

Insufficient permissions error

Posted: Mon Feb 11, 2008 4:41 pm
by John
How does SYSPERMS compare between the servers where it works and where it doesn't?