Change permissions of all records

telenut · Post by **telenut** » Tue Nov 13, 2007 10:03 am

Hi,

I would like to use the group permissions, but is there a way to change these permissions for the complete database?

Post by **Thorsten** » Tue Nov 13, 2007 10:47 am

Hi,

not in the graphical frontend...

bye
Thorsten

telenut · Post by **telenut** » Tue Nov 13, 2007 10:50 am

I've noticed

But can it be done with a simple sql command in phpmyadmin?

Post by **Thorsten** » Tue Nov 13, 2007 10:51 am

Hi,

yes, you have to change the group_id in faqdata_groups.

bye
Thorsten

telenut · Post by **telenut** » Tue Nov 13, 2007 2:02 pm

thx!

worked with following sql command:
UPDATE `phpmyfaq`.`faqdata_group` SET `group_id` = '2' WHERE `faqdata_group`.`group_id` = -1