<sec:authentication-provider xsi:type="wls:sql-authenticatorType">
        <sec:name>DB_secdoc</sec:name>
        <sec:control-flag>SUFFICIENT</sec:control-flag>
        <wls:data-source-name>JDBC-SecDoc</wls:data-source-name>
        <wls:plaintext-passwords-enabled>true</wls:plaintext-passwords-enabled>
        <wls:sql-get-users-password>SELECT password FROM tsq_users WHERE valid_account != 'N' and username = ?</wls:sql-get-users-password>
        <wls:sql-user-exists>SELECT username FROM tsq_users WHERE valid_account != 'N' and username = ?</wls:sql-user-exists>
        <wls:sql-list-member-groups>SELECT short_name FROM tsq_user_role_grants g ,tsq_roles r,tsq_users u WHERE g.usr_id = u.id and g.rle_id = r.id and u.valid_account != 'N' and u.username = ?</wls:sql-list-member-groups>
        <wls:sql-list-users>SELECT username FROM tsq_users WHERE valid_account != 'N' and username LIKE ?</wls:sql-list-users>
        <wls:sql-get-user-description>SELECT display_name FROM tsq_users WHERE valid_account != 'N' and username = ?</wls:sql-get-user-description>
        <wls:sql-list-groups>SELECT short_name FROM tsq_roles WHERE short_name LIKE ?</wls:sql-list-groups>
        <wls:sql-group-exists>SELECT short_name FROM tsq_roles WHERE short_name = ?</wls:sql-group-exists>
        <wls:sql-is-member>SELECT u.username FROM tsq_user_role_grants g ,tsq_users u WHERE u.id = g.usr_id and rle_id = ( select id from tsq_roles where short_name = ? ) AND usr_id = ( select id from tsq_users where valid_account != 'N' and username = ? )</wls:sql-is-member>
        <wls:sql-get-group-description>SELECT name FROM tsq_roles WHERE short_name = ?</wls:sql-get-group-description>
        <wls:password-style>HASHED</wls:password-style>
        <wls:sql-create-user>INSERT INTO tsq_users ( id,username , password , display_name) VALUES (tsq_seq.nextval, ? , ? , ? )</wls:sql-create-user>
        <wls:sql-remove-user>DELETE FROM tsq_users WHERE valid_account != 'N' and username = ?</wls:sql-remove-user>
        <wls:sql-remove-group-memberships>DELETE FROM tsq_user_role_grants WHERE rle_id = ( select id from tsq_roles where short_name = ? ) or usr_id = ( select id from tsq_users where valid_account != 'N' and username = ? )</wls:sql-remove-group-memberships>
        <wls:sql-set-user-description>UPDATE tsq_users SET display_name  = ? WHERE valid_account != 'N' and username = ?</wls:sql-set-user-description>
        <wls:sql-set-user-password>UPDATE tsq_users SET password = ? WHERE valid_account != 'N' and username = ?</wls:sql-set-user-password>
        <wls:sql-create-group>insert into tsq_roles(id, short_name, name) values (tsq_seq.nextval, ?, ?)</wls:sql-create-group>
        <wls:sql-set-group-description>UPDATE tsq_roles SET name = ? WHERE short_name =  ?</wls:sql-set-group-description>
        <wls:sql-add-member-to-group>INSERT INTO tsq_user_role_grants (id,rle_id,usr_id) VALUES( tsq_seq.nextval , ( select id from tsq_roles where short_name = ?),(select id from tsq_users where valid_account != 'N' and username = ?))</wls:sql-add-member-to-group>
        <wls:sql-remove-member-from-group>DELETE FROM tsq_user_role_grants WHERE rle_id = ( select id from tsq_roles where short_name = ? ) AND usr_id = ( select id from tsq_users where valid_account != 'N' and username = ? )</wls:sql-remove-member-from-group>
        <wls:sql-remove-group>DELETE FROM tsq_roles WHERE short_name = ?</wls:sql-remove-group>
        <wls:sql-remove-group-member>DELETE FROM tsq_user_role_grants WHERE rle_id = ( select id from tsq_roles where short_name = ? )</wls:sql-remove-group-member>
        <wls:sql-list-group-members>SELECT username FROM tsq_user_role_grants g ,tsq_roles r,tsq_users u WHERE g.usr_id = u.id and g.rle_id = r.id and r.short_name = ? and u.valid_account != 'N' and u.username like ?</wls:sql-list-group-members>
      </sec:authentication-provider>