I am working on a web project, the backend Javaand Mysql, the client includes web(html5)and app(IOS/Android), I have some doubts about the development of a system account.
There are 3 different types of account:
- The store , the store will have its own website,
- Customer , customer store / product through the application (IOS / Android),
- Admin , manage the entire system.
My main idea of authentication:
The table will have account/ role/ permission, since the administrator and the client will have a rather complicated problem with user rights, the client also has a different permission due to their behavior in history.
I decided to use Apache Shirobecause of its simplicity and distributed session.
My question is:
(1) Should I create a single account table or three separate account tables.
(2) Any design advice for 3 tables:
account/ role/ permission?
source
share