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 “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.”
The table may have several rows 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:
select * from syssecmechs
