Skip site navigation (1) Skip section navigation (2)

Re: Security Query

From: Vishal Arora <aroravishal22(at)hotmail(dot)com>
To: Carol Walter <walterc(at)indiana(dot)edu>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Security Query
Date: 2007-11-13 07:33:10
Message-ID: BLU110-W24EDFFFB4927B44C8C3E82A9800@phx.gbl (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
From the psql client, you can view ACL permission summaries by using the \z slash command. This command displays all access permissions in the currently connected database. To see permissions on a specific object, specify that object's name as a parameter to the \z command. You can use a regular expression in place of a name to see privileges on a group of objects. 

> To: pgsql-admin(at)postgresql(dot)org> From: walterc(at)indiana(dot)edu> Subject: [ADMIN] Security Query> Date: Mon, 12 Nov 2007 09:22:35 -0500> > Is there a query I can run that will tell me what access my users > have to various database objects?> > Thanks,> Carol Walter> > ---------------------------(end of broadcast)---------------------------> TIP 2: Don't 'kill -9' the postmaster
Climb to the top of the charts!  Play Star Shuffle:  the word scramble challenge with star power.

In response to

pgsql-admin by date

Next:From: frant101Date: 2007-11-13 10:37:55
Subject: pg_dumpall error
Previous:From: Scott MarloweDate: 2007-11-12 16:47:53
Subject: Re: HELP: I removed file pg_log, how can I recover?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group