Where is the "Allow Notifications" Property Stored?

[Braden S_]

On our instance the "Allow Notifications" setting is read only for non admin users. Nobody on my team remembers modifying this but we have a user where "Allow Notifications" is disabled and is unable to turn that setting on. We were unable to find where this value is stored to enable notifications for this user. 

[SanjivMeher]

Open the user table and check the Notification field for that user. If it is disabled, check the updated by field. You mayn't get the accurate result, who updated it, but you have the option there to activate it by just changing it to enable

[sachin_namjoshi · Accepted solution]

 Notifications preferences are stored in cmn_notif_message table.

you can search particular notifications for user and enable them.

But, in your case, it seems that allow notifications is disabled for particular user.

This is maintained in flag "Notification" in sys_user record. You can enable notifications for user in user record.

sys_user.LIST and pull notification column

Regards,

Sachin

[Braden S_]

Great info. I was able to enable the "Allow Notifications" for the user. Thank you!