A system table, syssecmechs, provides information about the security mechanisms and security services supported by Adaptive Server. The table, which is dynamically built when you query it, contains these columns:
sec_mech_name is the name of the security mechanism; for example, the security mechanism might be “dce” or “NT LANMANAGER.”
available_service is the name of a security service supported by the security mechanism; for example, the security service might be “unified login.”
Several rows may be in the table for a single security mechanism: one row for each security service supported by the mechanism.
To list all the security mechanisms and services supported by Adaptive Server, run this query:
select * from syssecmechs
The result might look something like:
sec_mech_name available_service ------------------------------ -------------------- dce unifiedlogin dce mutualauth dce delegation dce integrity dce confidentiality dce detectreplay dce detectseq
