The database server startup command start_iq has options that set the permission level of some database and server functions.
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 System Administration Guide: Volume 1 > Sybase IQ Startup Command Line Options that Control Permissions and Utility Guide > start_iq Database Server Startup Utility for more details on these options and the permission level values and defaults.