How do I set all users notifier to off using a SQL Script? (Article # 322)
View products that this article applies to.
Problem:
How do I set all users notifier to off using a SQL Script?
Resolution:
To set all users notifier to OFF - you can use the follow SQL:
/*** To set the notifier to OFF, set x_notifier = 0 ***/
Update table_user
SET x_notify = 0
/* Check the notifier setting for each user */
SELECT login_name, x_notify
FROM table_user
Applies To: