The database server startup command start_asiq has options that set the permission level of some database and server functions. These options are listed in the following table.
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_asiq; 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” and Chapter 1, “Running the Database Server” in the Sybase IQ Utility Guide for more details on these options and the permission level values and defaults.
