set user's default database/schema in Sybase IQ -

i googled , find nothing. short story, created user , granted table in sybase. when try

select * table1 

it didn't work. error show permission denied: don't have permission select "table1" , try add dbname before table name , works :

select * dbname.table1 

i suspect user default database else want set dbname default database. know how this?

this has nothing database names (or login policies). given comment "dbname" user owns table, here's what's happening.

when specify table name without owner, server has figure out table mean. first looks table own name. if doesn't find one, looks tables owned groups member of. suspect 1 of these groups has table named "table1" not have permission select from.

when specify table name with owner, server knows table use. since do have permission select table, results want.