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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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.
http://www.faqs.org/docs/ppbook/x19270.htm
> 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.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct
From | Date | Subject | |
---|---|---|---|
Next Message | frant101 | 2007-11-13 10:37:55 | pg_dumpall error |
Previous Message | Scott Marlowe | 2007-11-12 16:47:53 | Re: HELP: I removed file pg_log, how can I recover? |