Thread: User restrictions

User restrictions

From
ebmb
Date:
 Hi all,
 how can I make user restrictions to commands like "\du; \l; \dn". Is
it possible???

 Thanks in advance!

 EBMB.


Re: User restrictions

From
John DeSoi
Date:
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