THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
- Create a database named
SecurityDatabase
using DB manager in the administration console. - Create two tables
Users
andGroups
to store user credential and group information.
In the DB manager portlet copy and paste the above SQL into SQL Commands box and select theCode Block SQL SQL create table users(username varchar(15),password varchar(15)); create table groups(username varchar(15),groupname varchar(15)); insert into users values('userone','p1'); insert into users values('usertwo','p2'); insert into users values('userthree','p3'); insert into groups values('userone','admin'); insert into groups values('usertwo','admin'); insert into groups values('userthree','user');
SecurityDatabase
database and press Run SQL button to create the tables.
...