Restricting ODBC to only one table

am531

New Member
Is it possible to restrict ODBC connection to just one table out of hundreds in a large database? Preferrably read-only access too.

The server is 10.1C02 on AIX, the client is on Windows, native Progress ODBC.

Seems to be a trivial request, but I can't find any clues.

Thanks!


Andrew.
 
Yes:

make sure you are the DBA user and do:

Code:
grant select on  pub.<tablename>  to <username>;
commit;

Regards,

casper.
 
Thanks! But I was not clear in my question, sorry. The problem is not that much in privileges control, as in the amount of time it takes the application (UPS WorldShip if it matters) to start up. At start up it loads the whole database schema, all tables, their fields and relations. As it happens it takes 6 minutes right now because the database is large and complex.

So, what I'm really looking for is to restrict the schema visible to ODBC, so that the user does not have a way to see all other tables at all, their presence.

Is that possible?


Andrew.
 
Back
Top