Loading...
 
Features / Usability

Features / Usability


Can Tiki do row level security?

posts: 24 Australia

Hi all,

I've been searching for an answer all day and I've hit a roadblock. I'm wondering if someone can enlighten me on this: is there a way to limit what parts of a tracker (rows) a user sees depending on their group permissions or category permissions?

So what I mean by that is, say we have 3 items in a tracker (let's call it TRACKER _X). It has one field for DEPARTMENT, and another field for BUDGET.

Two items belong to DEPARTMENT "Finance". One item belongs to DEPARTMENT "Administration".

Now lets assume I'm a "Finance" person who belongs in the group "Finance". I don't want to see "Administration" line items when I log in. I don't want to use TRACKER Filter to manually change what I see as I'm not supposed to see another department's data, so I want it to automatically show the relevant items depending on my DEPARTMENT only, when I log in...

The only way I could think of doing something like this was to use two different pages and use PluginList to only pre-filter things relevant to me.

Note I need edit and view access for only my / my group's line items, which I think I can do in the tracker permissions?

Any guidance would be much appreciated 😊

Thank you!

posts: 24 Australia
If that's not possible is there a way to hide the items button when viewing the details of a tracker item?

posts: 24 Australia
Marc Laporte wrote:

Yes. Look in the "Permissions" section

Attached is a screenshot of how I use.

Best regards,

Marc


Thank you Marc, that's partly what I'm looking for. The permission you have set is on the field (column) level, yes?

The other thing I was hoping for is if the same tracker is used for multiple departments they need to see all fields, but just for their departments. Is that possible?


posts: 24 Australia

A further update - I think I have figured out what I was doing wrong - I needed to:

  1. Create a group
  2. Set the tracker itself so I could view my own group
  3. Use a trackerlist to filter by group


That worked a tread :-D

One last thing, is there a way you can hide the Items button as per the attached?


Upcoming Events

1)  21 Mar 2024 18:00 GMT-0000
Tiki Roundtable Meeting
2)  25 Mar 2024 17:00 GMT-0000
29th anniversary WikiBirthday (With Ward Cunningham)
3)  18 Apr 2024 18:00 GMT-0000
Tiki Roundtable Meeting
4)  16 May 2024 18:00 GMT-0000
Tiki Roundtable Meeting
5)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
8)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9) 
Tiki birthday
10)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting