> Datamata SQL Portal > About > Features


Datamata SQL Portal implements two roles: users, who access the databases, and administrators, who configure and manage such access. These roles are supported by the following feature sets:

Users Can

  • browse database objects through a GUI folder-tree interface;

  • enter and execute SQL statements in the SQL Pad. Browse and export execution results;

  • browse and execute database stored procedures;

  • browse, query, modify, and export data in a graphical manner through the data maintenance form. No SQL knowledge is required;

  • change password, which will be encoded and completely confidential.
  • Administrators Can

  • do all Datamata SQL Portal administration from any web browser, from anywhere on the Internet. All changes are effective immediately and there is never a requirement to restart the server;

  • add new and remove old database connections in real time;

  • organize connections in connection groups, when a large number of databases is present;

  • create and maintain user groups. Assign database access permissions to user groups;

  • create and maintain user accounts. Assign direct database permissions to users, or assign users to user groups from which the permissions will be inherited, or both;

  • monitor active user sessions;

  • monitor connection pool with an option to close connections.
      ©2003-2004 Datamata Corporation All rights reserved.