Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2014
    Posts
    2

    Unanswered: Grant select access to view but not underlying table

    Hi,

    I have got a table where different users are required to access only a subset of the table. Each user has its own postgres account.

    My idea was to create different views with the corresponding WHERE statements and grant select access to the views for the users. But how do I prevent then that the users can directly query the source table?

    So far I have not managed to allow access to the views but not the source table.

    Any hint and idea is welcome
    Rgds

    Max

  2. #2
    Join Date
    Apr 2014
    Posts
    2
    Nobody got an idea? Is this even possible within Postgres?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •