Hi, I need to add one more column to Umbraco 7.4.1 user ( backend) table and save data during user registration along with other fields . I want to know the best way to achieve this requirement .
I don't think you should add anything to the Umbraco tables, for a few reasons but the main one being when you upgrade it will cause you problems.
I would consider creating a custom table which stores your unique id and a user id which relates to the Umbraco user table.
You'll have to write a query to pull that back, but with PetaPoco being in the core this should be a trivial task.
Dave, I am very much convinced with your first comment upgrade will cause problem, thats is the main reason I have posted my query here so that may get some assistance around that but the another link you shared seemed for fronted member while I need to implement 2 factor authentication which will be authenticate by google mobile app for backend users. Approach is very clear to me the only above task I am looking for any simple example or source code . For 2f on backend users I took the reference of this project which is also a Angular Js project and Umbraco 7.4.1 also based on Angular
https://github.com/tjoudeh/AngularJSTwoFactorAuthentication/blob/master/README.md
Adding field to Umbraco User Table
Hi, I need to add one more column to Umbraco 7.4.1 user ( backend) table and save data during user registration along with other fields . I want to know the best way to achieve this requirement .
Thanks
Hi ,
Do you mean a user or a member.
Users are people who can log in to the Umbraco backend.
Members are used for loggin in on your website.
If it's the last than you can just add a property to the member type.
Dave
Hi Dave, Its User since I want to implement 2f auth (google authenticator app ) for backend user and need to store a unique key per user in db
I don't think you should add anything to the Umbraco tables, for a few reasons but the main one being when you upgrade it will cause you problems.
I would consider creating a custom table which stores your unique id and a user id which relates to the Umbraco user table. You'll have to write a query to pull that back, but with PetaPoco being in the core this should be a trivial task.
Hi,
I think you can use this for what you want to do.
https://github.com/Shazwazza/UmbracoIdentity
Dave
Dave, I am very much convinced with your first comment upgrade will cause problem, thats is the main reason I have posted my query here so that may get some assistance around that but the another link you shared seemed for fronted member while I need to implement 2 factor authentication which will be authenticate by google mobile app for backend users. Approach is very clear to me the only above task I am looking for any simple example or source code . For 2f on backend users I took the reference of this project which is also a Angular Js project and Umbraco 7.4.1 also based on Angular https://github.com/tjoudeh/AngularJSTwoFactorAuthentication/blob/master/README.md
@Dev, Can you please share some idea around this ?
Hi, Any sample on backoffice database manipulation ?
is working on a reply...