Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION cwmars.change_passwd(userid INT, newpasswd TEXT, passwdtype TEXT DEFAULT 'main')
- RETURNS VOID AS $$
- DECLARE
- newsalt TEXT;
- BEGIN
- SELECT actor.create_salt(passwdtype) INTO newsalt;
- PERFORM actor.set_passwd(userid, passwdtype, md5(newsalt || md5(newpasswd)), newsalt);
- END;
- $$ LANGUAGE 'plpgsql';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement