Originally Posted by MichaelM
Do you know what that query would be?

update ubbt_USER_PROFILE set USER_CANNOT_PM=1;

would set everyone's PM rights to not allowed.

If you run this one:

ALTER TABLE ubbt_USER_PROFILE CHANGE USER_CANNOT_PM USER_CANNOT_PM TINYINT( 1 ) NULL DEFAULT '1'

it would set PM rights default to not allowed for new users.

[Linked Image from siemons.org]