Re: User restrictions - Mailing list pgsql-general

From John DeSoi
Subject Re: User restrictions
Date
Msg-id 99AC53D2-C26A-4EC8-BD9D-EFBCA08D28F6@pgedit.com
Whole thread Raw
In response to User restrictions  (ebmb <ebmb@hotmail.com>)
List 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


pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Views- Advantages and Disadvantages
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Views- Advantages and Disadvantages