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 4.1
edited by christoph_lechleitner@iteg_at
on 2013-01-22 12.10:58
Change comment: Clarifying semantics of defaultDomain config property and domain parameter

Summary

Details

Page properties
Content
... ... @@ -41,12 +41,28 @@
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  )))|(((
47 47  Optional. Defaults to an empty string.
48 48  
49 -The login domain to use for principals when the request did not contain a domain.
61 +If set to an empty string, the domain parameter of request queries does not get checked but is filled in in returned principals.
62 +
63 +If set to a non-empty string, requests for other domains are refused.
64 +
65 +Support for databases maintaining multiple authentication domains might be added in the future, but I do not believe multi-domain setups even exist outside the LDAP/ADS world.
50 50  )))
51 51  |(((
52 52  {{code language="none"}}
... ... @@ -104,15 +104,16 @@
104 104  )))
105 105  |(((
106 106  {{code language="none"}}
107 -userIdsByGroupIdQuery
123 +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.
128 +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
131 +{{code language="none"}}SELECT u.userId, u.userName, u.mailAdr
132 + 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 +688979
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/688979/org.clazzes.login.sql (work in progress)