Managing users with Postgresql

Question

Our system will run on a local network with no more than 50 clients that connect to the same local server. We are creating a DB user for each client, to take advantage of the postgresql privilege system.

1) Analyzing the "performance", its OK to have ~ 50 DB users instead of reimplementing a custom system?

2) (SOLVED) How can the user check (what SQL statement) what permission he has in a table?

Solution:

SELECT HAS_TABLE_PRIVILEGE('user','table','insert')

I prefer to not reimplement the system, since a good security system isn't trivial to implement.

rmwaite · Accepted Answer · 2008-10-17 01:39:12Z

2

To answer the user/performance question: probably not. The only real risk would depend on how many users have unique security permissions (for example, if every one of those 50 users had different permissions on each table/schema in the database). In practice this should never happen, and as long as you have a sane group system for permissions, you should be fine.

answered Oct 17, 2008 at 1:39

rmwaite

9179 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Managing users with Postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related