The database server
26
"Checkpoints and the checkpoint log" on page 668 of the book ASA User’s
Guide
–gd command-line option
Set permissions required to start a database.
[ dbsrv7 | dbeng7 ] -gd [ dba | all | none ] ...
All operating systems and servers.
This is the permission required for a user to cause a new database file to be
loaded by the server. The level can be one of the following:
♦
dba Only users with DBA authority can start new databases.
♦
all All users can start new databases.
♦
none Starting new databases is not allowed.
The default setting is ALL for the personal database server and DBA for the
network database server. Both uppercase and lowercase syntax is acceptable.
The following set of steps illustrates how to use the
–gd option for the
network database server.
1 Enter a password in the
util_db.ini
file in your SQL Anywhere
win32
directory:
[UTILITY_DB]
pwd=mypwd
2 Start the network database server:
dbsrv7 -x tcpip -n myserver -gd dba
3 Connect to the utility database from Interactive SQL.
The following command assumes that myserver is the default database
server:
dbisql -c "uid=dba;pwd=mypwd;dbn=utility_db "
4 Start a database:
start database asademo
on myserver;
5 Connect to the database you have started:
connect
to myserver
database asademo
user DBA identified by SQL
Function
Syntax
Applies to
Description
Example
To Next Page
Loading...