User`s guide

218 Chapter 14: Database Administration
• Connect as: Sets the connection privileges. Available options are Normal,
SYSDBA or SYSOPER.
See Also
• User Interface
• Connect to DB
• Advanced Configuration
• Database Service Names and SID
• Database TNS Alias
14.4.3 Advanced Configuration
Figure 99: Advanced Configuration
• Set User Level: Shows the available user modes.
• Basic: This user level is for users who are doing regular maintenance and
fresh installations or upgrades of the database schema.
• Support: This user level is mainly used by Vizrt’s support personnel and
skilled administrators who are doing special customizations to an existing
installation or fixing common errors found in schemas.
• R&D: This user level is for use by Vizrt’s R&D department when doing
development or searching for bugs that is not solved by customer support.
• Advanced Options: Shows the available options.
• Enable Recreate/Recompile options: This enables the Recreate/Recompile
options in the Schema Status window and the button to recreate AQ tables
in Extended Info-AQ & Purge Job.
• Enable option to have different name on tablespace: Enables the user to
select a different tablespace name. Default is the same as Schema name.
• Enable support imports: Enables "support only"-version in the combo box
for selecting version for import. This is to import a single schema without
first installing a new schema, so that Vizrt can debug the schema. Also
enables "Imp.All Schemas in Dump" option.
• Add Destroy=Y to all imports: Overwrites tablespaces if already found.