0

I'm trying to grant access so that users can access all user information about themselves + non-sensitive information about others in the user table.

I thought user would inherit permissions from anonymous user which would give them access to the non-sensitive data of all users. This doesn't seem to be the case.

Is there a simple way to do this?

screenshot of user permissions

Screenshot of anonymous permissions

Ray Kanani
  • 261
  • 1
  • 3
  • 8

1 Answers1

1

Figured out to create an SQL view for the private user info and set permissions for those columns. Set the remaining columns as public.

Ray Kanani
  • 261
  • 1
  • 3
  • 8