Re: User restrictions

From: John DeSoi <desoi(at)pgedit(dot)com>
To: ebmb <ebmb(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: User restrictions
Date: 2007-05-09 20:19:47
Message-ID: 99AC53D2-C26A-4EC8-BD9D-EFBCA08D28F6@pgedit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On May 8, 2007, at 1:10 PM, ebmb wrote:

> how can I make user restrictions to commands like "\du; \l; \dn". Is
> it possible???

No. If you a user connect directly to the database, they can query
the system catalogs. So even if you somehow disabled the psql
command, they could still execute something like "SELECT * from
pg_database".

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-05-09 20:24:56 Re: Views- Advantages and Disadvantages
Previous Message Dann Corbit 2007-05-09 20:18:22 Re: Views- Advantages and Disadvantages