pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedprivileges
6+ messages / 4 participants
[nested] [flat]
* privileges
@ 2001-05-21 11:49 Cwhisperer <Cwhisperer@vo.lu>
0 siblings, 0 replies; 6+ messages in thread
From: Cwhisperer @ 2001-05-21 11:49 UTC (permalink / raw)
To: pgsql-admin
Hello,
how to show all the privileges of an user or group?
does there exist information on how to set privileges?
Best regards,
Cwhisperer
----------------------------------------------
Download the UD Agent and truly be a part of a
world-changing project. The National Foundation
for Cancer Research (NFCR) Centre for Drug
Discovery in the Department of Chemistry at the
University of Oxford, England, is working with
United Devices and our Member Community in the
search for new drugs in the treatment of cancer.
read more at http://www.ud.com
Join the VisualOnline Team against Cancer
http://members.ud.com/services/teams/team.htm?id=24ABFE16-09E9-4DEB-9A28-535A4B07D33C
-----------------------------------------------
^ permalink raw reply [nested|flat] 6+ messages in thread
* privileges
@ 2008-08-28 20:37 Carol Walter <walterc@indiana.edu>
0 siblings, 2 replies; 6+ messages in thread
From: Carol Walter @ 2008-08-28 20:37 UTC (permalink / raw)
To: pgsql-admin
Hello,
I asked this question yesterday, but perhaps I did so in an
unintelligible way. I didn't get any answer that time. Someone
usually answers my questions, so I must not have asked it very well.
I have a new database that I'm building for a faculty research
project. I created a role called app_admin. I granted the app_admin
role to my user name. When I try to describe the table using the
"\d" psql command, it tells me there are no relations. When I issue
that command logged as postgres instead of my username, all the
tables are listed. Since this is a new server, I thought perhaps the
database connection wasn't right but I can change to another database
that I have privileges to and I can describe the tables in that
database just fine.
Please help me with this. I have listed the privileges with the "\z"
and it shows me that my app_admin roles has all privs to all tables
and sequences. I tried to grant the role to my username, thinking
that it might not have worked the first time. The system says that
that username already has that role, so that's not the problem.
Thanks,
Carol
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: privileges
@ 2008-08-28 20:49 Richard Broersma <richard.broersma@gmail.com>
parent: Carol Walter <walterc@indiana.edu>
1 sibling, 1 reply; 6+ messages in thread
From: Richard Broersma @ 2008-08-28 20:49 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
On Thu, Aug 28, 2008 at 1:37 PM, Carol Walter <walterc@indiana.edu> wrote:
> I granted the app_admin role to my user name. When I try to
> describe the table using the "\d" psql command, it tells me there are no
> relations.
I believe that this link explains the problem you are seeing:
http://www.postgresql.org/docs/8.3/interactive/role-membership.html
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: privileges
@ 2008-08-28 20:51 Richard Broersma <richard.broersma@gmail.com>
parent: Richard Broersma <richard.broersma@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Richard Broersma @ 2008-08-28 20:51 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
On Thu, Aug 28, 2008 at 1:49 PM, Richard Broersma
<richard.broersma@gmail.com> wrote:
> On Thu, Aug 28, 2008 at 1:37 PM, Carol Walter <walterc@indiana.edu> wrote:
>
>> I granted the app_admin role to my user name. When I try to
>> describe the table using the "\d" psql command, it tells me there are no
>> relations.
>
> I believe that this link explains the problem you are seeing:
> http://www.postgresql.org/docs/8.3/interactive/role-membership.html
Take a look the the inherits keyword.
--
Regards,
Richard Broersma Jr.
Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: privileges
@ 2008-08-28 21:24 Carol Walter <walterc@indiana.edu>
parent: Richard Broersma <richard.broersma@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Carol Walter @ 2008-08-28 21:24 UTC (permalink / raw)
To: Richard Broersma <richard.broersma@gmail.com>; +Cc: pgsql-admin
The problem is solved. It wasn't until I tried to work with the
database in PhpPgAdmin that I got an error message that pointed me to
the solution. I had not granted privileges to the schemas. I had
never had to grant privs to a schema before and the documentation
seemed to indicate that it was only necessary in certain cases. This
didn't seem to fit my circumstances.
Anyway, thanks for your help.
Carol
On Aug 28, 2008, at 4:51 PM, Richard Broersma wrote:
> On Thu, Aug 28, 2008 at 1:49 PM, Richard Broersma
> <richard.broersma@gmail.com> wrote:
>> On Thu, Aug 28, 2008 at 1:37 PM, Carol Walter
>> <walterc@indiana.edu> wrote:
>>
>>> I granted the app_admin role to my user name. When I try to
>>> describe the table using the "\d" psql command, it tells me there
>>> are no
>>> relations.
>>
>> I believe that this link explains the problem you are seeing:
>> http://www.postgresql.org/docs/8.3/interactive/role-membership.html
>
> Take a look the the inherits keyword.
>
>
> --
> Regards,
> Richard Broersma Jr.
>
> Visit the Los Angeles PostgreSQL Users Group (LAPUG)
> http://pugs.postgresql.org/lapug
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: privileges
@ 2008-08-28 21:51 Ben Kim <bkim@tamu.edu>
parent: Carol Walter <walterc@indiana.edu>
1 sibling, 0 replies; 6+ messages in thread
From: Ben Kim @ 2008-08-28 21:51 UTC (permalink / raw)
To: Carol Walter <walterc@indiana.edu>; +Cc: pgsql-admin
Could it be the search path (schema) issue? Just a quick thought...
Regards,
Ben Kim
On Thu, 28 Aug 2008, Carol Walter wrote:
> Hello,
>
> I asked this question yesterday, but perhaps I did so in an unintelligible
> way. I didn't get any answer that time. Someone usually answers my
> questions, so I must not have asked it very well. I have a new database that
> I'm building for a faculty research project. I created a role called
> app_admin. I granted the app_admin role to my user name. When I try to
> describe the table using the "\d" psql command, it tells me there are no
> relations. When I issue that command logged as postgres instead of my
> username, all the tables are listed. Since this is a new server, I thought
> perhaps the database connection wasn't right but I can change to another
> database that I have privileges to and I can describe the tables in that
> database just fine.
>
> Please help me with this. I have listed the privileges with the "\z" and it
> shows me that my app_admin roles has all privs to all tables and sequences. I
> tried to grant the role to my username, thinking that it might not have worked
> the first time. The system says that that username already has that role, so
> that's not the problem.
>
> Thanks,
>
> Carol
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2008-08-28 21:51 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-21 11:49 privileges Cwhisperer <Cwhisperer@vo.lu>
2008-08-28 20:37 privileges Carol Walter <walterc@indiana.edu>
2008-08-28 20:49 ` Richard Broersma <richard.broersma@gmail.com>
2008-08-28 20:51 ` Richard Broersma <richard.broersma@gmail.com>
2008-08-28 21:24 ` Carol Walter <walterc@indiana.edu>
2008-08-28 21:51 ` Ben Kim <bkim@tamu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox