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