Cisco Systems 3.3 Manual De Usuario

GRANT EXECUTE ON dbo.CSNTAuthUserPap TO ciscosecure

GO

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