Where is the "Allow Notifications" Property Stored?

Braden S_ · ‎07-15-2019

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.

sachin_namjoshi · ‎07-15-2019

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

View solution in original post

pathumharsh · Thursday

hi Sachin, I also face same issue, I tried to make the notification disable to enable, but it automatically changes to disable again after I change it to enable. how can i resolve it?

Braden S_ · ‎07-16-2019

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