Table 16-1: Process for administering network-based
security
Step
|
Description
|
See
|
|---|
1. Set up the configuration
files:
|
Edit the libtcl.cfg file.Edit
the objectid.dat file. Edit the interfaces file
or Directory Service.
|
|
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 must create a keytab file
for server entries.
|
|
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_r or
Open Client Client-Library to connect to Adaptive Server,
specifying the security services you want to use.
|
|
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”
|
