The group and user columns in sys_user_grmember table can be made mandatory?

olivierneveu
Tera Contributor

‎07-25-2023 11:37 AM

The group and user columns in sys_user_grmember table are not mandatory, so there is no strict way to get correct data. In our instance we have lot of record where group column is empty.
Out of the box there is an ACL to prevent this bad data but our dev write code using gliderecord which ignore ACL.

Not a fan to change OOB existing tables but any drawback by making this 2 columns mandatory ?

0 Helpfuls
  • 918 Views
3 REPLIES 3

Ravi Chandra_K
Kilo Patron
Kilo Patron

‎07-25-2023 07:45 PM - edited ‎07-26-2023 05:01 AM

Hello @olivierneveu 

Greetings!

yes, you can make them mandatory. I believe it will not have any major impacts/side effects making them mandatory.

If possible, Change the GlideRecord to GlideRecordSecure which will not ignore ACLs

Please hit the thumb and Mark as correct based on Impact!!

 

Kind Regards,

Ravi Chandra.

0 Helpfuls

olivierneveu
Tera Contributor
In response to Ravi Chandra_K

‎07-26-2023 04:28 AM

OOB they are not mandatory, checked in a personal instance. Changing behaviour of 100+ developers is out of reach.

0 Helpfuls

Ravi Chandra_K
Kilo Patron
Kilo Patron
In response to olivierneveu

‎07-26-2023 04:59 AM

sorry my bad,  I have modified my comment. Thank you!

Kind Regards,

Ravi Chandra.

0 Helpfuls