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 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
To 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

Summary

Details

Page properties
Content
... ... @@ -41,18 +41,6 @@
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"}}
56 56  defaultDomain
57 57  {{/code}}
58 58  )))|(((
... ... @@ -116,16 +116,15 @@
116 116  )))
117 117  |(((
118 118  {{code language="none"}}
119 -usersByGroupIdQuery
107 +userIdsByGroupIdQuery
120 120  {{/code}}
121 121  )))|(((
122 122  Optional. Required for //getGroupMembers// feature.
123 123  
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.
112 +SQL template for a prepared statement to query the user IDs of the members of the group specified by a groupId.
125 125  
126 126  Example:
127 -{{code language="none"}}SELECT u.userId, u.userName, u.mailAdr
128 - FROM groups AS g, users AS u, memberships AS mgroupName
115 +{{code language="none"}}SELECT u.userId FROM groups AS g, users AS u, memberships AS mgroupName
129 129   WHERE g.groupId=?
130 130  AND m.groupId = g.id
131 131   AND u.id = m.userId
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -688787
1 +688791
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/LOGIN/pages/688787/org.clazzes.login.sql (work in progress)
1 +https://clazzes.atlassian.net/wiki/spaces/LOGIN/pages/688791/org.clazzes.login.sql (work in progress)