Forums: User can see and edit their own data only: - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

User can see and edit their own data only: user of a same group to be able to see/edit data related to their own Rate Topic: -----

#1 User is offline   kouba 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 3
  • Joined: 27-March 18

Posted 12 July 2018 - 03:52 PM

Hi,

I am a bit confused how to put together these advanced security parameter: User can see and edit their own data only and group permission. My database is kind of consolidated (or centralized) data from different levels (Country --> city --> hub, ).
I will have couple users per country, and I want to allow user of a given country be able to see/edit data of this same country. I have databased- based login system. This is how am doing: adding join statement in sql level and go up to country level to compare country_code (country table) and user_country_code (user table), and apply this to every (add, edit, view) tables under country level. but I feel it rises the complexity and can add some page load time. I thought I would be easier to combine group Permission and "User can see and edit their own data only" features. any advice would be welcome.

Thanks
0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 15830
  • Joined: 03-February 03

Posted 12 July 2018 - 11:05 PM

Advanced Security and User Group Permissions are two two different and independents settings.

Advanced Security restricts access to certain records in any given database table. User Group Permissions restrict access to certain tables or to actions users can perform.

So yes, you can use Advanced Security and User Group Permissions together but I don't think it answers your question.
Best regards,
Sergey Kornilov
0

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic