Cisco Systems 3.3 Manual De Usuario

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

if exists (select * from sysobjects where id = object_id(`dbo.CSNTFindUser’) and sysstat & 

0xf = 4)

drop procedure dbo.CSNTFindUser

GO

CREATE PROCEDURE CSNTFindUser

@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.CSNTFindUser 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.