Open Source Document Management System | OpenKM

I am using OpenKM 6.3 on Windows server 2008 R2 as well as on Windows 7 with MySQL database.
I have 5 users, 4 with ROLE_USER and 1 with ROLE_ADMIN (myself). I have removed the access rights of folders and documents for ROLE_USER. And y mistake I removed security rights for myself on a folder and applied recursively. So now I am not able to see any folders and documents.
Can you please help me to revert the rights???
I guess it can be done from database but only UUIDs are stored in it.

did you removed ROLE_ADMIN to okmAdmin ? otherwise you can login with this super user.
did you changed default database configuration ( embeded hypersonic ) or you've configured MySQSL ( we suggest this one for production )

The problem is solved....
I know the date when I have uploaded documents i selected the document uuids from node_base table uploaded within the date range and inserted the records in node_user_permission with desired rights...

Note (For other forum Users): Please don't try this unless & until you have a backup and you know MySQL or other database queries and their impacts.

If you change grants from database, you got a unsynchronized data between openkm database and search engine, for updating it you must go to Administration -> Utilities -> Rebuild indexes and choose Lucene indexes

I have done metadata on these files and if I am rebuilding indexes then the metadata done on the files are lost. I had the backup so I have restored it again. But if I am rebuilding indexes then I am loosing metadata done on the files which I cannot tell users to do again as the number of files stored are more than 4000.

If you choose rebuild indexes options you shoult not loosing metadata asociated to the documents. If you've removed the association between document and metadata then I can understand, otherwise should maintan it.

Can you make some screenshots. 1 document with metadata( I want to see metadata tab) , 2 search, 3 result of search after you've selected "lucene indexes"