You can refer to the data_dump.sql script inside the WEB-INF/config/database directory.
Take postgresql as an example:
Replace the ? mark with the group_id you created and remove some unnecessary permission from the SQL script.
-- Admin
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_administration');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_moderation');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_moderation_post_remove');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_moderation_post_edit');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_moderation_topic_move');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_moderation_topic_lockUnlock');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_moderation_approve_messages');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_create_sticky_announcement_topics');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_vote');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_create_poll');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_karma_enabled');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_bookmarks_enabled');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_attachments_download');
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_moderation_log'); -- novo
INSERT INTO jforum_roles (group_id, name) VALUES (?, 'perm_full_moderation_log'); -- novo
--
-- View Forum
--
INSERT INTO jforum_roles (name, group_id) VALUES ('perm_forum', ?);
INSERT INTO jforum_role_values (role_id, role_value) VALUES ((SELECT CURRVAL('jforum_roles_seq')), '1');
--
-- Anonymous posts
--
INSERT INTO jforum_roles (name, group_id) VALUES ('perm_anonymous_post', ?);
INSERT INTO jforum_role_values (role_id, role_value) VALUES ((SELECT CURRVAL('jforum_roles_seq')), '1');
--
-- View Category
--
INSERT INTO jforum_roles (name, group_id) VALUES ('perm_category', ?);
INSERT INTO jforum_role_values (role_id, role_value) VALUES ((SELECT CURRVAL('jforum_roles_seq')), '1');
--
-- Create / Reply to topics
--
INSERT INTO jforum_roles (name, group_id) VALUES ('perm_read_only_forums', ?);
INSERT INTO jforum_role_values (role_id, role_value) VALUES ((SELECT CURRVAL('jforum_roles_seq')), '1');
--
-- Enable HTML
--
INSERT INTO jforum_roles (name, group_id) VALUES ('perm_html_disabled', ?);
INSERT INTO jforum_role_values (role_id, role_value) VALUES ((SELECT CURRVAL('jforum_roles_seq')), '1');
--
-- Attachments
--
INSERT INTO jforum_roles (name, group_id) VALUES ('perm_attachments_enabled', ?);
INSERT INTO jforum_role_values (role_id, role_value) VALUES ((SELECT CURRVAL('jforum_roles_seq')), '1');
--
-- Reply only
--
INSERT INTO jforum_roles (name, group_id) VALUES ('perm_reply_only', ?);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES ((SELECT CURRVAL('jforum_roles_seq')), '1');
--
-- Reply without moderation
--
INSERT INTO jforum_roles (name, group_id) VALUES ('perm_reply_without_moderation', ?); -- novo
INSERT INTO jforum_role_values ( role_id, role_value) VALUES ((SELECT CURRVAL('jforum_roles_seq')), '1');
--
-- Moderation of forums
--
INSERT INTO jforum_roles (name, group_id) VALUES ('perm_moderation_forums', ?);
INSERT INTO jforum_role_values ( role_id, role_value) VALUES ((SELECT CURRVAL('jforum_roles_seq')), '1');
And see
http://code.google.com/p/jforum2/wiki/Permissions for the detail descripton of each permission
After manually insertion to the database, you need to reload the JForum application to take effect.
