Progress
DataServer for
Microsoft SQL Server
Guide


Security

Using the DataServer for SQL Server™ involves following the security guidelines required by both the Progress database and the MSS data source. By default, Progress allows unrestricted access to data sources, so at minimum, you should follow the guidelines that the data source requires for your applications.

Progress Security

The Progress database management system has no minimum security requirements. You can, however, impose security features on any Progress database or schema holder. There are four levels of application security that you can impose:

For more information on Progress security, see the data security chapter in the Progress Programming Handbook.

SQL Server™ Database Security

As noted previously, you should follow the security guidelines that your MSS data source has established for your applications. The SQL Server™ database might require that all users supply a valid login name and password to access it. Data source access security typically has four levels—system administrator, database owner, database object owner, and public:

NOTE: There are specific security requirements for accessing data with the DataServer that relate to creating a schema holder. For details, see the "Creating a Schema Holder" section in Configuring the DataServer."


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095