Skip to Content

Changes for page org.clazzes.login.sql

Last modified by christoph_lechleitner@iteg_at on 2013-07-15 01.30:42
From version 2.1
edited by christoph_lechleitner@iteg_at
on 2013-01-18 05.10:06
Change comment: First throw at hopefully complete configuration specs
To version 3.1
edited by christoph_lechleitner@iteg_at
on 2013-01-18 05.27:29
Change comment: Added deactivateUserStatement, renamted and extended group members query

Summary

Details

Page properties
Content
... ... @@ -41,6 +41,18 @@
41 41  )))
42 42  |(((
43 43  {{code language="none"}}
44 +deactivateUserStatement
45 +{{/code}}
46 +)))|(((
47 +Not implemented yet. Optional. Required for //deactivateUser// feature.
48 +
49 +SQL template for a prepared statement to deactivate a user.
50 +
51 +Example:
52 +{{code language="none"}}UPDATE users SET encryptedPassword='{disabled}' WHERE userId=?{{/code}}
53 +)))
54 +|(((
55 +{{code language="none"}}
44 44  defaultDomain
45 45  {{/code}}
46 46  )))|(((
... ... @@ -104,15 +104,16 @@
104 104  )))
105 105  |(((
106 106  {{code language="none"}}
107 -userIdsByGroupIdQuery
119 +usersByGroupIdQuery
108 108  {{/code}}
109 109  )))|(((
110 110  Optional. Required for //getGroupMembers// feature.
111 111  
112 -SQL template for a prepared statement to query the user IDs of the members of the group specified by a groupId.
124 +SQL template for a prepared statement to query the user IDs, user names and e-mail-addresses of the members of the group specified by a groupId.
113 113  
114 114  Example:
115 -{{code language="none"}}SELECT u.userId FROM groups AS g, users AS u, memberships AS mgroupName
127 +{{code language="none"}}SELECT u.userId, u.userName, u.mailAdr
128 + FROM groups AS g, users AS u, memberships AS mgroupName
116 116   WHERE g.groupId=?
117 117  AND m.groupId = g.id
118 118   AND u.id = m.userId
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -688791
1 +688787
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/LOGIN/pages/688791/org.clazzes.login.sql (work in progress)
1 +https://clazzes.atlassian.net/wiki/spaces/LOGIN/pages/688787/org.clazzes.login.sql (work in progress)