Try OpenEdge Now
skip to main content
Core Business Services - Security and Auditing
Security : Security in OpenEdge : Data management : Database security
Database security
The OpenEdge RDBMS provides the following security features:
*Identity management for database utilities, and SQL and ABL database servers.
*Setting up compile-time and run-time database, table, and field authorization. For more information on managing ABL for this purpose, see OpenEdge Deployment: Managing ABL Applications.
*Schema trigger security using r-code CRCs. For more information, see OpenEdge Deployment: Managing ABL Applications.
*Assigning an ABL database security administrator, creating internal database user accounts, and obtaining a report of users who are authenticated to use the database. For information on the administration tools available for this purpose, see OpenEdge Development: Basic Database Tools (using character mode) and the Data Administration online help (using GUI mode).
*Using SQL to create SQL users and assign DBAs (SQL database administrators).
*Authorizing access to SQL tables and columns by granting, verifying, and revoking privileges.
*Sealing auditing data using a MAC key. For more information on MAC keys, see Cryptography. For more information on using MAC keys to seal auditing data, see Sealing the audit data.
*Working with operating system security.
*Configuring the database server as an SSL server to enable SSL connections from ABL and SQL clients. For more information on SSL in OpenEdge, see Application network security using SSL.
For more information on security for the OpenEdge RDBMS, see OpenEdge Data Management: Database Administration.
For more information on authorization and authentication in OpenEdge SQL, see Core user authentication and authorization. For more information on SQL data security, see OpenEdge Data Management: SQL Development.