Utility Database Server Security

SAP Sybase IQ includes a phantom database, called the utility database, that has no physical representation, and which can contain no data.

The utility database can run on any SAP Sybase IQ server. In SAP Control Center, the server for the utility database is known as the Utility Server.

The utility database permits a narrow range of specialized functions. It enables you to execute database file manipulation statements such as CREATE DATABASE and DROP DATABASE without first connecting to a physical database.

You can also retrieve database and connection properties from the utility database. These properties apply to databases you create when connected to the utility database.

• Defining the Utility Database Name When Connecting
  You cannot specify a database file when starting the utility database, because no database file is associated with that database. You must specify the database name when connecting.
• Defining the Utility Database Password
  Define the user ID DBA for the utility database.
• Permission to Execute File Administration Statements
  A separate level of security, which controls the creating and dropping of databases, provides additional database security. The -gu database server command line option controls who can execute the file administration statements.