1 2 createprocsp_logininfo3 @account varchar(60)=NULL4 as5 6 /*
7 ** check if user has sso role, proc_role will also do auditing
8 ** if required. proc_role will also print error message if required.
9 */10 11 if(proc_role("sso_role")= 0)12 return(1)13 14 dbcc iseadmin("logininfo",@account)15 16 /*
17 ** If there was an error, the specific message was already sent to client
18 ** within the iseadmin() module.
19 */20 21 if @@error != 0
22 return(1)23 24 return(0)25 26 /* end of sp_logininfo */27