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.
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.
