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.”
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 this query:
select * from syssecmechs
The result might look something like this:
sec_mech_name available_service ------------------------------ -------------------- dce unifiedlogin dce mutualauth dce delegation dce integrity dce confidentiality dce detectreplay dce detectseq
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
