December 20, 2019 at 10:53 am
I got this table with a header called 'userID' wich have the registers 1, 2, 3 or 4. I've inserted a lot of registers identifying differents userID depending of wich user made changes. Now I need to create users in my dataBase for each userID (user1, user2, user3, user4) but when the user enter in this database I want them to see just the data that has the same user ID.
For example. If I enter to database with user1. And I want to make a select from this tables. I want to be able just to se the registers of this datatable if the userID is 1 (Depending on the user connected to de database)
This can me possible to be mannaged with permissions? or maybe I have to create a trigger to change the select and show just the data based on the userId using as a reference de user connected?
Let me know in the comments below
Thank you very much
December 20, 2019 at 12:17 pm
This sounds like a case for row-level security.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply