File: 08_first_login.sql

package info (click to toggle)
credcheck 4.4-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 460 kB
  • sloc: ansic: 1,991; sql: 864; makefile: 22; sh: 1
file content (7 lines) | stat: -rwxr-xr-x 346 bytes parent folder | download 
1
2
3
4
5
6
7
 
LOAD 'credcheck';

SET credcheck.password_change_first_login = true;
CREATE USER aaa PASSWORD 'DummY';
-- verify that credcheck_internal.force_change_password is present after user creation
SELECT 1 FROM pg_catalog.pg_db_role_setting WHERE setrole='aaa'::regrole AND 'credcheck_internal.force_change_password=true'=ANY(setconfig);
DROP USER aaa;