Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Matt McDawell: "Your practical knowledge & experience, supported by your dedication and hard work set new standards. Taking you into account is the best decision our company has made".
Paul Slicky: "I just want to say this has been the fastest, greatest, and most coopertive tool I have ever had. It turned out to be easy to use and very slick. Keep up the good work".

More

Add your opinion

MaxDB Maestro online Help

Prev Return to chapter overview Next

Specifying group option

Specify group options according to your needs. The detailed description is given below.
 

Name

The field contains the editable new group name as it was set on the previous wizard step.

 

Mode

Define here the database user class RESOURCE or STANDARD for users of the new group.

STANDARD - Access to data and database procedures that were defined by other database users and for which the user has been given privileges. Definition of view tables, synonyms and temporary tables

RESOURCE - Definition of data and database procedures. Granting of privileges for these database objects to other database users

 

Enable connect

You use the option to define whether a user of the group can open database sessions.

 

Exclusive

Check the option to prevent the group users from opening several different database sessions simultaneously.

 

Timeout

The timeout value determines the maximum duration of inactivity in a database session. The duration of inactivity is the time interval between ending an SQL statement and sending the next SQL statement. As soon as the timeout value is exceeded, the database system ends the database session with a ROLLBACK. The value is specified in seconds and must be between 30 and 32400.

 

Cost warning

Use the field to specify the estimated SELECT cost value beyond which a user of the group receives A warning. In this case, the group user is asked whether he or she really wants to execute the SQL statement. The Cost limit value must be less than the Cost warning value.

 

Cost limit

Enter here the estimated SELECT cost value beyond which the SQL statement is not executed.

The Cost limit value must be greater than the Cost warning value.



Prev Return to chapter overview Next