Cisco Systems Servers Manuale Utente

 The following example routine creates in Microsoft SQL Server a procedure 
named CSNTExtractUserClearTextPw, the default procedure used by 
Cisco Secure ACS for CHAP/MS-CHAP/ARAP authentication. Table and 
column names that could vary for your database’s schema are presented in 
variable text. For more information about data type definitions, procedure 
parameters, and procedure results, see the 

.

if exists (select * from sysobjects where id =

object_id(`dbo.CSNTExtractUserClearTextPw’) and sysstat & 0xf = 4)

drop procedure dbo.CSNTExtractUserClearTextPw

GO

CREATE PROCEDURE CSNTExtractUserClearTextPw

@username varchar(64)

AS

SET NOCOUNT ON

IF EXISTS( SELECT

FROM

WHERE

= @username )

SELECT 0,

,

,"No Error",

FROM

WHERE

= @username

ELSE

SELECT 3,0,"odbc","ODBC Authen Error"

GO

GRANT EXECUTE ON dbo.CSNTExtractUserClearTextPw TO ciscosecure

GO

 details the input provided by Cisco Secure ACS to the stored 

procedure supporting PAP authentication. The stored procedure should accept the 
named input values as variables.