# The following asadmin command creates a JDBC Security Realm. It was created with a Derby database in mind, thus all table and column names are in uppercase. For non-Derby databases you might need to respect the actual cases.
asadmin create-auth-realm --classname com.sun.enterprise.security.auth.realm.jdbc.JDBCRealm --property user-name-column=USERNAME:password-column=PASSWORD:digestrealm-password-enc-algorithm=none:group-name-column=GROUPNAME:group-table=USERS_GROUPS:user-table=USERS:datasource-jndi=jdbc/myapp-ds:jaas-context=jdbcRealm:db-user=admin:db-password=admin:digest-algorithm=none:group-table-user-name-column=USERNAME jdbcRealm