Hi,
I have attached two SQL files ,one of them can be restore with MySQL Administrator and the other one can be restored with Navicat,Maybe these help you.
For your second question:
for example for this authorization " hasPermission(departement,'professor')" ,you must have this row in Permission table
------------------------------------------------
target action
recipient discriminator
Department:1 professor prof(this is username of registered user) user
---------------------------------------------
Department:1 (1 is id of the current department in "department" table)
For inserting above row to table you must write the following code
securityService.grantPermission(department,"professor",user)
user here is for example prof(either logged in user or you can get him from database) , that when you call grantPermission ,"prof" insert into recipient column and "user " insert in discriminator column.
But there is some problem here ,that is ,you
must have also this row in Permission table,otherwise you got Authorization exception,(if you log in with staff user and you want to grant above permission)
---------------------------------------------------------------
target action recipient discriminator
Department:1 seam.grant-permission staff user
----------------------------------------------------------------
This is a problem that i have asked here
http://seamframework.org/Community/UsingPermissionManagerToGrantAt last,i think we must create our own PermissionManager class from Seam source and omit the line 102
of that class(But this is a guess).
Khosro.
Khosro.