Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

Can I have a setting in postgres server to allow to filter some records in some table according to login user?

Can I have a setting in postgres server to allow to filter some records in some table according to login user?

Thx
0
dickywkt
Asked:
dickywkt
1 Solution
 
gplanaCommented:
You can create views. A view is like a table but defined by a SELECT instead of a list of columns.
http://www.postgresql.org/docs/9.2/static/sql-createview.html

You can then grant rights to that view to the user, and revoke rights to the base table.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now