What database tables does Apache Shiro require?

java apache shiro
mehdi shahdoost picture mehdi shahdoost · Mar 30, 2011 · Viewed 9k times · Source

I want to use Apache Shiro and MySQL for my Realm. What tables and fields does Shiro need to work?

Answer

Les Hazlewood picture Les Hazlewood · Mar 30, 2011

Shiro doesn't require database tables to function. Shiro users can use whatever datastore they want to model or manage users, groups, permissions etc.

It is a Shiro Realm's responsibility to act as the bridge to your data (however you want to represent it) and return it in a format that Shiro understands.

Because Shiro does not impose a data model upon you, this is what allows it to work with so many backends (LDAP, Active Directory, RDBMS, File System, etc).

If you want to use an RDBMS as your backing data store, check out Shiro's JdbcRealm source code to give you an idea of what your tables might look like. This is just an example though. You could have any table structure you wish.

Related questions

how to make log4j to write to the console as well

Is there any way to tell to log4j to write its log to the file and to the console? thanks there are my properties: log4j.rootLogger=DEBUG,console,R log4j.rootLogger=INFO, FILE log4j.appender.CONSOLE=…

Read More
Tomcat is not running even though JAVA_HOME path is correct

When I am trying to run tomcat using startup.bat I get the following error, The JAVA_HOME environment variable is not defined correctly This environment variable is needed to run this program NB: JAVA_HOME should point to a …

Read More
How to read Excel cell having Date with Apache POI?

I'm using Apache POI 3.6, I want to read an excel file which has a date like this 8/23/1991. switch (cell.getCellType()) { ... ... case HSSFCell.CELL_TYPE_NUMERIC: value = "NUMERIC value=" + cell.getNumericCellValue(); break; ... } But it takes the numeric value type and returns …

Read More