Introduction

---

Administering a database server involves maintaining global connection settings as well as databases, server-side procedures, users, and scheduled events. All of this information is stored in the configuration file specified via the TDBISAMEngine ServerConfigFileName property. DBISAM offers the ability to administer a database server both locally through the TDBISAMEngine component and remotely through the TDBISAMSession component. Both types of administration are very similar except for some minor differences.

Local Administration

---

Local administration of a database server involves calling methods of the TDBISAMEngine component directly. The following methods are all for local administrative use:


Remote Administration

---

Remotely administering a database server involves connecting to the server's administration port using a TDBISAMSession component that has the following properties set properly:


Once you have set up the TDBISAMSession properties properly for administrative access you can proceed to call the TDBISAMSession Open method or set the TDBISAMSession Active property to True. This will cause the remote session to attempt to connect to the database server on the administrative port. Provided that you have set up everything properly, you will connect to the database server on the administrative port and can then proceed to use the remote administrative methods of the TDBISAMSession component to administer the database server.

The remote administration methods of the TDBISAMSession component are identical to the local methods of the TDBISAMEngine component except that the TDBISAMSession methods are named *Remote* instead of *Server*. Also, there are no StartAdminServer or StopAdminServer methods, and the StartMainServer and StopMainServer methods are called StartRemoteServer and StopRemoteServer, respectively. For a complete list of the remote administration methods please see the TDBISAMSession component.

The following example shows how to set up the TDBISAMSession properties for remotely administering a database server, connect to the database server, add a new user (not an administrator), and then add user rights to the "AccountingDB" database for this user:

begin
   with MyDBISAMSession do
      begin
      SessionType:=stRemote;
      RemoteEncryption:=True;
      { Assume the default encryption password in use }
      RemoteAddress:='192.168.0.1';
      RemotePort:=12006;
      RemoteUser:='Admin';
      RemotePassword:='DBAdmin';
      Open;
      try
         AddRemoteUser('Test','Test123456','Test User',False);
         AddRemoteDatabaseUser('AccountingDB','Test',
                               [drRead,drInsert,drUpdate,drDelete]);
      finally
         Close;
      end;
      end;
end;