SQL Anywhere database - Need Help - Users and ODBC Pass-Thru Queries

Author

Need Help - Users and ODBC Pass-Thru Queries

Paul

2005-06-30, 1:24 pm

Hello everyone.

I am setting users and groups in Sybase Central using ASA 9 from an upsized
Access Application (UI front-end in Access, back-end data ASA).

I am able to access the linked tables and queries from the UI in the
front-end directly data via the application with no problem, but when I try
to run Pass-Through queries, it tells me that the table is "Not Found". If
I were to delete the user "user", I can run the Pass-Through queries again,
but if I were to put the user "user" back in again the same problem happens.

I've gone through and granted full permissions to the group "MANAGER", in
which "user" is a member. "user" itsel has no permissions, but I am
thinking that "user" should inherit the permissions from MANAGER.

So I tried to grant full access to all tables to "user" but I still am not
able to run Pass-Through queries

Finally, on the client machine I'm running from, the ODBC DSN is set up so
that user "dba" (password "sql") logs in to the DB via the ODBC connection.
I've even changed that to "user" and its password, but that still didn't
solve the problem.

I'm reviewing the Database Admin document for ASA but I get nowhere. Is
there anything else I should be checking?

Thank you in advance for your help. I'll also keep looking on my own to
resolve this. If I get the solution I'll also post it here.

Paul Grossman
PAULGRO Consulting LLC

Paul

2005-06-30, 1:24 pm

UPDATE:

It's not ODBC that's causing the problem.

I go into ISQL logged in as "user" and still get "table not found" error.
I double checked the permissions for the table in question and it has full
permissions for "user",
I also granted access to PUBLIC just to make sure - and still can not select
from the table.

BUT when I log in as DBA, I can do a select against the table in ISQL.

Please help. Thanks,

"Paul" <paul.grossman@paulgro.com> wrote in message
news:42c432ae$1@foru
ms-2-dub...
> Hello everyone.
>
> I am setting users and groups in Sybase Central using ASA 9 from an
> upsized Access Application (UI front-end in Access, back-end data ASA).
>
> I am able to access the linked tables and queries from the UI in the
> front-end directly data via the application with no problem, but when I
> try to run Pass-Through queries, it tells me that the table is "Not
> Found". If I were to delete the user "user", I can run the Pass-Through
> queries again, but if I were to put the user "user" back in again the same
> problem happens.
>
> I've gone through and granted full permissions to the group "MANAGER", in
> which "user" is a member. "user" itsel has no permissions, but I am
> thinking that "user" should inherit the permissions from MANAGER.
>
> So I tried to grant full access to all tables to "user" but I still am not
> able to run Pass-Through queries
>
> Finally, on the client machine I'm running from, the ODBC DSN is set up so
> that user "dba" (password "sql") logs in to the DB via the ODBC
> connection. I've even changed that to "user" and its password, but that
> still didn't solve the problem.
>
> I'm reviewing the Database Admin document for ASA but I get nowhere. Is
> there anything else I should be checking?
>
> Thank you in advance for your help. I'll also keep looking on my own to
> resolve this. If I get the solution I'll also post it here.
>
> Paul Grossman
> PAULGRO Consulting LLC
>

Greg Fenton

2005-06-30, 8:23 pm

Paul wrote:
>
> BUT when I log in as DBA, I can do a select against the table in ISQL.
>

It sounds like the table is owned by DBA. When logged in as "user" can you:

SELECT * from "DBA".my_table_name

or check the table's owner with:

SELECT creator,tname from syscatalog where tname = 'my_table_name'

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links