Row ID as a role & row owner

Ask for Help
1

is there anything wrong with assigning a row id as a role and row owner?

I have an app with projects table.
Each user can access 1 project but the project name can change.
is there anything wrong with assigning the project row ID as the role to the user and the row id in the projects table as the row owner?

2

Probably would be fine as long as you are ok with all users being private users.

1 Like
3

yes all app users are private users.
I have another row owner column with value of admin in every row. So users with a role admin can see all rows.

1 Like