PDA

View Full Version : Checking for user permissions...


Robert Basil
Sat 31st Jul '04, 5:08pm
We have a forum setup for our staff. We use user permission to limit access to this staff.

We just had to remove an admin and now we are finding out the the admin has given a lot of other users permission to view this forum.

What Query can I run on the database to see all of the users that have access to see foruimID 37

Thanks in advance for your help!

P.S. Running VB2

Steve Machol
Sat 31st Jul '04, 5:12pm
I think this will do it:

SELECT userid FROM access WHERE forumid=37;

Robert Basil
Sat 31st Jul '04, 5:14pm
I think this will do it:

SELECT userid FROM access WHERE forumid=37;

That did it Steve, thanks!