PDA

View Full Version : Mass update access mask


Night Owl
01-19-2003, 11:15 PM
I have several dozen members of my board who have been given access to forum X via access masks. I would like to return all those members to the default setting for that forum.

Would this be the appropriate syntax?

UPDATE access SET accessmask="-1" WHERE forumid="131"

Thank you!

Xenon
01-20-2003, 02:42 PM
use this:

DELETE FROM access WHERE forumid=131

Night Owl
01-20-2003, 03:18 PM
THank you!!!