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:
- System administrators can grant or revoke permissions to other users to create or own a wide type of objects; for example, databases.
- Database owners can grant other users permission to access or modify a database or its objects.
- A user can be the owner of objects in a database owned by another user.
- Public database objects can be accessed by any users without restriction.
- The DataServer for SQL Server™ will allow you to use either the Windows NT or SQL Server™ authentication model for your connection to the SQL Server™ data source. For more information on database security, see Microsoft’s SQL Server™ documentation.
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 |