Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Post Unanswered: Deny access to informix via Access

    We're using an informix database that is running on a aix machine.
    All clients are windows terminals.
    Now some users connect via access instead of the erp application directly to the database, how can we prevent that from happening ?

  2. #2
    Join Date
    Aug 2002
    You can't deny access to an application. You can deny access to users.
    The fact that they can use access proves that they have an Informix ODBC driver installed on their local machines. Throw that out and they can't access.
    Normally, an ERP systems always loggs on to the database server with one username.

    In that case just revoke all permissions from the other users in the database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts