Site:Developer stuff/Removing rights

Created 1/6/06 by Matthew Faulconer Created originally to remove rights from an account used for testing.

#check user's current rights
SELECT *
FROM user a, user_rights b
WHERE a.user_id=b.ur_user;

#The way rights work, there is one field that tracks all rights. 
#E.g. if you are a sysop and a beauracrat, you would have two designations in the same field
#running this code removes all the user's rights.
#Not have any rights is equivalent to creating a new user account.

#Remove all user's rights
#replace XXXX with actual user_id that you want to remove rights for.
UPDATE user_rights 
SET ur_rights="" 
WHERE ur_user=XXXX;