Home Explore Help
Register Sign In
github
/
spring-security
mirror of https://github.com/spring-projects/spring-security
2
0
Fork 0
Files Issues 0 Wiki
Tree: e366c65d17
Branches Tags
spring-security
/
hsqldb
/
acegisecurity.script

acegisecurity.script 2.5 KB
History Raw

1234567891011121314151617181920212223 
  1. CREATE TABLE USERS(USERNAME VARCHAR_IGNORECASE(50) NOT NULL PRIMARY KEY,PASSWORD VARCHAR_IGNORECASE(50) NOT NULL,ENABLED BOOLEAN NOT NULL)
    2. 

  2. CREATE TABLE AUTHORITIES(USERNAME VARCHAR_IGNORECASE(50) NOT NULL,AUTHORITY VARCHAR_IGNORECASE(50) NOT NULL,CONSTRAINT FK_AUTHORITIES_USERS FOREIGN KEY(USERNAME) REFERENCES USERS(USERNAME))
    3. 

  3. CREATE UNIQUE INDEX IX_AUTH_USERNAME ON AUTHORITIES(USERNAME,AUTHORITY)
    4. 

  4. CREATE TABLE ACLS(OBJECT_IDENTITY VARCHAR_IGNORECASE(250) NOT NULL,RECIPIENT VARCHAR_IGNORECASE(100) NOT NULL,PARENT_OBJECT_IDENTITY VARCHAR_IGNORECASE(250),MASK INTEGER NOT NULL,ACL_CLASS VARCHAR_IGNORECASE(250) NOT NULL,CONSTRAINT PK_ACLS PRIMARY KEY(OBJECT_IDENTITY,RECIPIENT))
    5. 

  5. SET IGNORECASE TRUE
    6. 

  6. CREATE USER SA PASSWORD "" ADMIN
    7. 

  7. INSERT INTO USERS VALUES('dianne','emu',TRUE)
    8. 

  8. INSERT INTO USERS VALUES('marissa','koala',TRUE)
    9. 

  9. INSERT INTO USERS VALUES('peter','opal',FALSE)
    10. 

  10. INSERT INTO USERS VALUES('scott','wombat',TRUE)
    11. 

  11. INSERT INTO AUTHORITIES VALUES('marissa','ROLE_TELLER')
    12. 

  12. INSERT INTO AUTHORITIES VALUES('marissa','ROLE_SUPERVISOR')
    13. 

  13. INSERT INTO AUTHORITIES VALUES('dianne','ROLE_TELLER')
    14. 

  14. INSERT INTO AUTHORITIES VALUES('scott','ROLE_TELLER')
    15. 

  15. INSERT INTO AUTHORITIES VALUES('peter','ROLE_TELLER')
    16. 

  16. INSERT INTO ACLS VALUES('net.sf.acegisecurity.acl.DomainObject:1','ROLE_SUPERVISOR',NULL,1,'net.sf.acegisecurity.acl.basic.SimpleAclEntry')
    17. 

  17. INSERT INTO ACLS VALUES('net.sf.acegisecurity.acl.DomainObject:2','marissa','net.sf.acegisecurity.acl.DomainObject:1',2,'net.sf.acegisecurity.acl.basic.SimpleAclEntry')
    18. 

  18. INSERT INTO ACLS VALUES('net.sf.acegisecurity.acl.DomainObject:2','ROLE_SUPERVISOR','net.sf.acegisecurity.acl.DomainObject:1',0,'net.sf.acegisecurity.acl.basic.SimpleAclEntry')
    19. 

  19. INSERT INTO ACLS VALUES('net.sf.acegisecurity.acl.DomainObject:3','scott','net.sf.acegisecurity.acl.DomainObject:1',14,'net.sf.acegisecurity.acl.basic.SimpleAclEntry')
    20. 

  20. INSERT INTO ACLS VALUES('net.sf.acegisecurity.acl.DomainObject:4','inheritance_marker_only','net.sf.acegisecurity.acl.DomainObject:1',0,'net.sf.acegisecurity.acl.basic.SimpleAclEntry')
    21. 

  21. INSERT INTO ACLS VALUES('net.sf.acegisecurity.acl.DomainObject:5','inheritance_marker_only','net.sf.acegisecurity.acl.DomainObject:3',0,'net.sf.acegisecurity.acl.basic.SimpleAclEntry')
    22. 

  22. INSERT INTO ACLS VALUES('net.sf.acegisecurity.acl.DomainObject:6','scott','net.sf.acegisecurity.acl.DomainObject:3',1,'net.sf.acegisecurity.acl.basic.SimpleAclEntry')
    23. 

  23. INSERT INTO ACLS VALUES('net.sf.acegisecurity.acl.DomainObject:7','scott','some.invalid.parent:1',2,'net.sf.acegisecurity.acl.basic.SimpleAclEntry')
    24.