Hi, i have encounter a problem in my customizing Sales approval system. If Customer exceed their credit limit, system will prompt the user id and password screen for superior to approve. But i don’t know how to verify the user id and password using C/AL. I really you all help. Thank you very much.
maybe this link is helpful http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=233 or search on “brute force” this forum. But i don’t think that this is working with the SQL-Authentication, because the table user contains no crypted password you can’t verify by the examples “brute force”… The users and even Passwords are stored in the master db, table sysuser. There is a stored procedure called sp_Password with some interesting content for your question: //QUOTE>> – CHECK OLD PASSWORD IF NEEDED – if (@self = 1 or @old is not null) if not exists (select * from master.dbo.sysxlogins where srvid IS NULL and name = @loginame and ( (@old is null and password is null) or (pwdcompare(@old, password, (CASE WHEN xstatus&2048 = 2048 THEN 1 ELSE 0 END)) = 1) ) ) begin raiserror(15211,-1,-1) return (1) end //<<QUOTE Maybe this help Bye Stefan