Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Configuring the DataServer : Creating a schema holder : Authorization and Authentication : Application-specific permissions
Application-specific permissions
In addition to the MS SQL Server database 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 an OpenEdge application that queries but does not update the employee table in the 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 select, 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 tables that the application accesses
*The type of access required to those tables