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 6.1
edited by christoph_lechleitner@iteg_at
on 2013-02-02 06.01:11
Change comment: Usable now, not pure WIP
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
Title
... ... @@ -1,1 +1,1 @@
1 -org.clazzes.login.sql
1 +org.clazzes.login.sql (work in progress)
Content
... ... @@ -41,28 +41,12 @@
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  )))|(((
59 59  Optional. Defaults to an empty string.
60 60  
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.
49 +The login domain to use for principals when the request did not contain a domain.
66 66  )))
67 67  |(((
68 68  {{code language="none"}}
... ... @@ -120,16 +120,15 @@
120 120  )))
121 121  |(((
122 122  {{code language="none"}}
123 -usersByGroupIdQuery
107 +userIdsByGroupIdQuery
124 124  {{/code}}
125 125  )))|(((
126 126  Optional. Required for //getGroupMembers// feature.
127 127  
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.
112 +SQL template for a prepared statement to query the user IDs of the members of the group specified by a groupId.
129 129  
130 130  Example:
131 -{{code language="none"}}SELECT u.userId, u.userName, u.mailAdr
132 - 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
133 133   WHERE g.groupId=?
134 134  AND m.groupId = g.id
135 135   AND u.id = m.userId
Confluence.Code.ConfluencePageClass[0]
Id
... ... @@ -1,1 +1,1 @@
1 -688821
1 +688791
Title
... ... @@ -1,1 +1,1 @@
1 -org.clazzes.login.sql
1 +org.clazzes.login.sql (work in progress)
URL
... ... @@ -1,1 +1,1 @@
1 -https://clazzes.atlassian.net/wiki/spaces/LOGIN/pages/688821/org.clazzes.login.sql
1 +https://clazzes.atlassian.net/wiki/spaces/LOGIN/pages/688791/org.clazzes.login.sql (work in progress)