Table can not be read despite giving all the Permissions

[Sabir Sohrab]

I am running a Sybase SQL Anywhere 5.5 (Multi-User) of a remort server and I am
Connecting to database with dbclient.exe

I have a client program (PB7.0) that reads info from the server. This works fine
when login as DBA. But when login as a USER the SELECT statement to read data
from the table returns (.SQLCode) -1. But i am able to view the same table from
sybase Central using the same USER login. What could be the problem ?

Thank You in Advance

Sabir

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp

[Chris Keating]

This is a problem with visibility versus permissions. Sybase Central always
qualifies the table owner as part of the query i.e., select * from
owner.tablename whereas you likely are calling select * from tablename.

This problem stems from development of your schema while logged in as DBA
and as such the table owner, unless qualified otherwise, is DBA. To make
that table visible without needing to qualify the table owner, you need to
make the owner a group and make the user a member of the group. If you are
not able to rebuild your database schema so that you have group as the table
owner, you can convert DBA to a group and add the users to that group. The
privileges of dba won't be inherited by the users.

/ck

"Sabir Sohrab" <eeke...@yahoo.ca> wrote in message
news:OuhvRPVTDHA.342@forums-2-dub...