Provide an editor window for running SQL commands, while providing complete change management as well as privilege controls over SQL execution.
Active+ is a convenient SQL work window, allowing the user to edit, save, recall, and print the SQL commands with ease. While the work area provides ease of use, Active+ provides serious controls on the SQL being executed as the schema owner can define restrictions to SQL commands that can be issued and executed from an Active+ window. Also, all SQL commands executed via Active+ are logged and users can be audited and profiled by viewing the log activity.
The solution architecture is highly scalable. It can support hundreds of users and thousands of devices. It has multiple options to support active-active or active-passive architectures.
Operating System Compatibility:
WindowsNT/2000 client connecting to ANY Database on the corporate network
Pentium 100MHz or higher
10MB hard disk space
64 MB RAM (128 MB recommended)
Ease of use in editing and executing SQL commands via an OLE window that allows the user to copy, cut, paste, print, recall and generate SQL commands.
Security controls on SQL access to the underlying database. A list of SQL command restrictions can be maintained by each schema owner for Active+ users.
Auditing of the SQL is provided when users access and run DDL and DML commands against the database. The statements are logged with Active Change Manager . Thus, user DDL/DML activity across the database instance can be reviewed when access is restricted via Active+.
Query Builder in Active+ allows the user to quickly generate SQL select, insert, update and delete statements via simple clicks
Build controls on data access by restricting specific select statements via Active+. E.g.: restrict "SELECT EMP_SALARY", will restrict any user from running a select statement on the EMP_SALARY table, while allowing the user to perform other routine actions.
Provide controlled access to database schemas such as production databases where the DML/DDL accesses must be restricted and sometimes audited.
Provide a means of protecting sensitive production data from being queried by general database user community, by providing SELECT controls on specific database tables.
Where sensitive information is handled by End Users via SQL and requires encryption, eg. Salary updates, credit card information updates, and other such confidential information.