Spring Security Tables

[sam101]

Hi,
I wanted to know if all Spring Security tables are needed. If not which are ones are needed. See the tables below.

USERS, AUTHORITIES, GROUPS, GROUP_AUTHORITIES, AND GROUP_MEMBERS


Thanks

[Rob Winch]

It depends on what you are utilizing. For example, if you are using in memory or ldap authentication you might not need any of the tables. The JdbcDaoImpl by default uses the schema defined in the reference. However, you can customize the queries on it to use a totally different schema. An example of the default queries and how to customize them can be found on this thread. If this still doesn't meet your needs you can write your own AuthenticationProvider.

[sam101]

It depends on what you are utilizing. For example, if you are using in memory or ldap authentication you might not need any of the tables. The JdbcDaoImpl by default uses the schema defined in the reference. However, you can customize the queries on it to use a totally different schema. An example of the default queries and how to customize them can be found on this thread. If this still doesn't meet your needs you can write your own AuthenticationProvider.

We are going to have our user roles in DB. So wanted to know which all Spring tables we need to create. Do we need all five? Or which combinations we can use.

For example we have roles, admin, employee, regular. We will have user id tied to those roles.

[Rob Winch]

If you are not using groups, then you should not need any of the tables specified in A.1.1 Group Authorities

[sam101]

We want to use groups tables. So which all other tables we have to have.

Thanks

[Rob Winch]

All of the tables specified in A.1 User Schema and A.1.1 Group Authorities

[sam101]

We dont want authorities tables. We just have user names and groups such as supervisor, admin, employee etc.

What all tables we need for that.

Thanks

[Rob Winch]

Specify these as roles and ignore the groups tables.

[sam101]

So only use Users and Authorities table in appendix A.1??