Server command-line permission options

The database server startup command start_iq has options that set the permission level of some database and server functions. Table 8-1 lists these options.

Table 8-1: Startup options affecting permissions

Option

Description

Allowed values

Default

-gd level

Set permission required to start the database

DBA, ALL, NONE

DBA

-gk level

Set permission required to stop the server

DBA, ALL, NONE

DBA

-gl level

Set permission required to load data

DBA, ALL, NONE

ALL for servers started with start_iq; DBA for other servers

-gu level

Set permission required to execute utility commands, for example CREATE DATABASE and DROP DATABASE

DBA, ALL, NONE, UTILITY_DB

ALL

See “Controlling permissions from the command line” in Chapter 2, “Running Sybase IQ,” in the System Administration Guide: Volume 1 and Chapter 1, “Running the Database Server” in the Utility Guide for more details on these options and the permission level values and defaults.