Table data permission enquiries

(0) Share

Report

Posted on by Community Member

Dear All

Refer to the print screen below. This is a permission set created by my vendor

where table data for object ID 0 (all object) was granted the read, modify, delete right

Will this be an audit issues? or too much right was granted to users where they can modify most data?

I have the same question (0)

All responses (6)

Answers (2)

Suggested answer

Teddy Herryanto (Th... 14,008 Super User 2025 Season 2 on at

Like (0)

Report

RE: Table data permission enquiries

You have standard system creation and modified on every table. However, it only for record level and does not have before after.

If you want field level and have before after value, you need to setup change log.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Table data permission enquiries

Can i ask about the change log setup? If i don't select anything on the Log insertion / deletion / , will there be anything logged? is it a must to do so?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Table data permission enquiries

I must say, your website is very informative! and greatly done.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 89,830 Super User 2025 Season 2 on at

Like (1)

Report

RE: Table data permission enquiries

Hi, You can refer to Basic permissions to reset the minimum permission set.

Or, use Change Logs, Field Monitoring, or Data audit system fields features, which should solve the audit problem.

https://yzhums.com/3481/

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
Verified answer

Teddy Herryanto (Th... 14,008 Super User 2025 Season 2 on at

Like (0)

Report

RE: Table data permission enquiries

Seems like someone is not doing a good job setting up your permission.

That basically granting super access to all tables in BC.

The permission should be setup according to what they need to access. Otherwise, you might as well setup them as SUPER user.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,035 Moderator on at

Like (0)

Report

RE: Table data permission enquiries

ObjectID 0 means that they have these permissions for ALL the table objects in your solutions unless there are another line in the pemission set that defines that limits their permission. So the following lines in your setup seems to restrict access to some of the table. But with the Object ID 0 defined they will automatically have access to any new tables added to your installations as well as those who are not restricted further down in your setup.

Was this reply helpful? Yes No