Bingo!
Thanks very much
On 25 October 2011 13:47, Raghavendra wrote:
> On Tue, Oct 25, 2011 at 6:04 PM, Maton, Brett wrote:
>
>> Thanks for the replies.
>> Actually this was question posed by one of my colleagues, what he really
>> wants to know is if there is the equivalent of MySQL's
>>
>>
On Tue, Oct 25, 2011 at 6:04 PM, Maton, Brett wrote:
> Thanks for the replies.
> Actually this was question posed by one of my colleagues, what he really
> wants to know is if there is the equivalent of MySQL's
>
> select * from all_tab_privs_recd where grantee = 'your user'
>
> Thanks again,
>
Thanks for the replies.
Actually this was question posed by one of my colleagues, what he really
wants to know is if there is the equivalent of MySQL's
select * from all_tab_privs_recd where grantee = 'your user'
Thanks again,
Brett
On 25 October 2011 13:21, Venkat Balaji wrote:
> My answers
My answers are in line in RED -
How can I list a users permissions table by table?
>
> i.e. User Joe
> has read/write on table1
>
has read on table2
> no access on table 3
>
For a particular user you can use below function. You can write a SQL query
or script which takes table names from
Forgot to post the reference manual link. Here you go.
http://www.postgresql.org/docs/9.0/static/sql-grant.html
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, Oct 25, 2011 at 5:21 PM, Raghavendra <
raghavendra@enterprisedb.com> wrote:
> You ca
You can get it from psql terminal.
postgres=# \z table-name
---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/
On Tue, Oct 25, 2011 at 4:50 PM, Maton, Brett wrote:
> Hi,
>
> How can I list a users permissions table by table?
>
> i.e. User Joe
> has rea
