userdatabase.properties

这是linux下ssl vpn的实现程序

# This file contains the default resources for the explorer_accounts database
logon.user=SELECT * FROM users WHERE username=? AND password=?
select.users=SELECT * FROM users
select.user=SELECT * FROM users WHERE username=?
create.account=INSERT INTO users (username, email, password, fullname) VALUES(?,?,?,?)
assign.role=INSERT INTO user_roles (username, rolename) VALUES(?,?)
update.account=UPDATE users SET email=?, fullname=? WHERE username=?
delete.roles=DELETE FROM user_roles WHERE username=?
delete.account=DELETE FROM users WHERE username=?
delete.account.roles=DELETE FROM user_roles WHERE username=?
change.password=UPDATE users SET password=?, last_password_change=TODAY WHERE username=?
change.password.force=UPDATE users SET password=?, last_password_change=? WHERE username=?
select.role=SELECT * FROM roles WHERE rolename=?
select.roles=SELECT * FROM roles
create.role=INSERT INTO roles (rolename) VALUES(?)
delete.role.1=DELETE FROM roles WHERE rolename=?
delete.role.2=DELETE FROM user_roles WHERE rolename=?
select.user.roles=SELECT * FROM user_roles WHERE username=?