Utility Database Server Security

SAP Sybase IQ includes a phantom database, called the utility database, that has no physical representation.

There is no database file for this database, and the database can contain no data. The utility database can run on any SAP Sybase IQ server. In Sybase 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 is provided so that you can 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
  Specify the database name to start the utility database.
• 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.