Administering network-based security

Table 14-2 provides an overall process for using the network-based security functions provided by Adaptive Server. You must install Adaptive Server before you can complete the steps in Table 14-2.

**Table 14-2: Process for administering network-based security**
Step	Description	See
1. Set up the configuration files: libtcl.cfg objectid.dat interfaces (or Directory Service)	Edit the libtcl.cfg file.Edit the objectid.dat file. Edit the interfaces file or Directory Service.	“Setting up configuration files for security” The Open Client/Server Configuration Guide for your platform.
2. Make sure the security administrator for the security mechanism has created logins for each user and for the Adaptive Server and Backup Server.	The security administrator must add names and passwords for users and servers in the security mechanism. For DCE, the security administrator needs to create a keytab file for server entries.	The documentation supplied with your security mechanism. “Identifying users and servers to the security mechanism”.
3. Configure security for your installation.	Use sp_configure.	“Configuring Adaptive Server for security”.
4. Restart Adaptive Server.	Activates the use security services parameter.	“Restarting the server to activate security services”.
5. Add logins to Adaptive Server to support enterprise-wide login.	Use sp_addlogin to add users. Optionally, specify a default secure login with sp_configure.	“Adding logins to support unified login”.
6. Determine the security model for remote procedures and set up the local and remote servers for RPC security.	Use sp_serveroption to choose the security model (A or B).	“Establishing security for remote procedures”.
7. Connect to the server and use security services.	Use isql_dce or isql_r (if you are using DCE library services or security services) or Open Client Client-Library to connect to Adaptive Server, specifying the security services you want to use.	“Connecting to the server and using the security services”. The Open Client/Server Configuration Guide for your platform. “Security Features” topics page in the Open Client Client-Library/C Reference Manual.
8. Check the security services and security mechanisms that are available.	Use the functions show_sec_services and is_sec_services_on to check which security services are available. For a list of security mechanisms and their security services supported by Adaptive Server, use select to query the syssecmechs system table.	“Getting information about available security services”.