-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/58929/
-----------------------------------------------------------
(Updated May 3, 2017, 4:15 p.m.)
Review request for Ambari, Attila Magyar, Balázs Bence Sári, Eugene Chekanskiy,
Jonathan Hurley, Laszlo Puskas, Nate Cole, and Sebastian Toader.
Changes
-------
Updates due to reviewer suggestions.
Bugs: AMBARI-20907
https://issues.apache.org/jira/browse/AMBARI-20907
Repository: ambari
Description
-------
User management tables in the DB should be:
# users
Name |Type |Description
-------------------------------|----------|-----------
user_id |INTEGER |Internal unique identifier
principal_id |INTEGER |Foreign key from adminprincipal table
user_name |VARCHAR |Unique, case-insensitive, login
identifier expected to be used when logging into Ambari
create_time |TIMESTAMP |Creation time for this account in
Ambari
active |BOOLEAN |Active/not active flag
consecutive_failed_auth_attemps|INTEGER |The number a failed authorization
attempts since the last successful authentication
active_widgets_layout |VARCHAR |
display_name |VARCHAR |Cosmetic name value to show the user
in user interfaces
local_username |VARCHAR |Case-sensitive username to use when
impersonating user in facilities like Ambari Views
- Primary Key: `user_id`
- Foreign Key: `principal_id` -> `adminprincipal.principal_id`
# user_authentication
Name |Type |Description
----------------------|---------|------------
user_authentication_id|INTEGER |Primary key for this table
user_id |INTEGER |Foreign key from users table
authentication_type |VARCHAR |Type of authentication system - LOCAL, LDAP,
KERBEROS, JTW, PAM, etc...
authentication_key |VARCHAR |Type-specific key (or identifier): LOCAL: the
user's password (digest); LDAP: the user’s distinguished name; KERBEROS: the
user’s principal; etc...
create_time |TIMESTAMP|Creation time of this record
update_time |TIMESTAMP|Update time for this record, can be used to
enforce password retention times
- Primary Key: `user_authentication_id`
- Foreign Key: `user_id` -> `users.user_id`
Diffs (updated)
-----
ambari-server/src/main/resources/Ambari-DDL-Derby-CREATE.sql b241dc271c
ambari-server/src/main/resources/Ambari-DDL-MySQL-CREATE.sql 670bf17594
ambari-server/src/main/resources/Ambari-DDL-Oracle-CREATE.sql 00b3248b25
ambari-server/src/main/resources/Ambari-DDL-Postgres-CREATE.sql f6af96807c
ambari-server/src/main/resources/Ambari-DDL-SQLAnywhere-CREATE.sql 64a0137f5b
ambari-server/src/main/resources/Ambari-DDL-SQLServer-CREATE.sql 22b2c3d7d5
Diff: https://reviews.apache.org/r/58929/diff/2/
Changes: https://reviews.apache.org/r/58929/diff/1-2/
Testing
-------
Tested creating new databases using Posgress, MySQL, and Derby.
_I have no way to test creating Oracle, MS SQL, and SQL Anywhere databases._
Thanks,
Robert Levas
