The proxy user that connects to the database table must have the following characteristics:
The user must appear to own the database tables or views being accessed. The connection user name must be able to refer to the table or view without using a qualifier to specify the owner.
The user must have permissions to perform any actions the adapter is configured to support. At a minimum, the user must have SELECT privilege on the database table or view (possibly including its underlying tables). If the adapter is configured to create, update, and delete users, for example, then the user must have SELECT, INSERT, UPDATE, and DELETE privileges.