skip to main content
OpenEdge Data Management: DataServer for ODBC
Configuring the DataServer : Creating a schema holder : Establishing permissions : Application-specific permissions
 
Application-specific permissions
In addition to the ODBC data-source permissions required by the DataServer, the required permissions for users depend on the applications that they are using. For example, a user who is running a application that queries but does not update the employee table in a data source must connect to the data source with a login name and password combination that provides at least select privileges for the employee table. For users who will manipulate data at runtime, the appropriate read, insert, update, and delete permissions must be granted as administered by the foreign (target) data source.
In summary, the login name (or user ID) and password combination required to run a particular application depends on the following:
*The data-source tables that the application accesses
*The type of access required to those tables
Note: The system administrator for your ODBC data source must establish all login name and password combinations with the appropriate data-source commands and procedures. See the documentation for your data source for information on granting user permissions.