pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem in Grant and Revoke Query
3+ messages / 3 participants
[nested] [flat]
* Problem in Grant and Revoke Query
@ 1998-07-29 09:50 root <elangog@wipinfo.soft.net>
0 siblings, 1 reply; 3+ messages in thread
From: root @ 1998-07-29 09:50 UTC (permalink / raw)
To: pgsql-sql
Hi
I am not able to set permission using Grant and Revoke
I tried t o revoke all permission from a table , but unfortunately
other users are able to make query on the table
Please give me more details on Grant and Revoke usage with few examples
Thanku
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] Problem in Grant and Revoke Query
@ 1998-07-29 12:02 James Olin Oden <joden@lee.k12.nc.us>
parent: root <elangog@wipinfo.soft.net>
0 siblings, 1 reply; 3+ messages in thread
From: James Olin Oden @ 1998-07-29 12:02 UTC (permalink / raw)
To: root <elangog@wipinfo.soft.net>; +Cc: pgsql-sql
> Hi
> I am not able to set permission using Grant and Revoke
> I tried t o revoke all permission from a table , but unfortunately
> other users are able to make query on the table
> Please give me more details on Grant and Revoke usage with few examples
>
Two questons:
1) Who owns the database in which you revoked the privlidges? Is that
user the one you were logged in as when you revoked the privlidges.
2) Could you send the exact SQL statement you typed to do this?
Perhaps there is something wrong in it.
...james
> Thanku
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [SQL] Problem in Grant and Revoke Query
@ 1998-07-30 14:09 G.Elangovan <elangog@wipinfo.soft.net>
parent: James Olin Oden <joden@lee.k12.nc.us>
0 siblings, 0 replies; 3+ messages in thread
From: G.Elangovan @ 1998-07-30 14:09 UTC (permalink / raw)
To: James Olin Oden <joden@lee.k12.nc.us>; +Cc: pgsql-sql
Let me explain the exact scenario
My project group owns the database ownership, as a project member i am
having permission to createuser , createdatabase and destroy(user and
database).
I tested the database in this way
database name is : mydb
table name is : ptable
database owner is : project-team
query is : revoke all on ptable from public
revoke all on ptable from group
and similraly for grant query
my query is to grant and revoke permission on "ptable" as owner
(project-team) and access thro my user account.
I am able to access database thro my account
Problem is
The grant and revoke is not working as expected.
I hope u got the exact idea about my problem
Thanku for ur reply and expecting friendship from u + reply for this
On Wed, 29 Jul 1998, James Olin Oden wrote:
>
> > Hi
> > I am not able to set permission using Grant and Revoke
> > I tried t o revoke all permission from a table , but unfortunately
> > other users are able to make query on the table
> > Please give me more details on Grant and Revoke usage with few examples
> >
>
> Two questons:
>
> 1) Who owns the database in which you revoked the privlidges? Is that
> user the one you were logged in as when you revoked the privlidges.
> 2) Could you send the exact SQL statement you typed to do this?
> Perhaps there is something wrong in it.
>
> ...james
>
> > Thanku
>
>
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-07-30 14:09 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-07-29 09:50 Problem in Grant and Revoke Query root <elangog@wipinfo.soft.net>
1998-07-29 12:02 ` James Olin Oden <joden@lee.k12.nc.us>
1998-07-30 14:09 ` G.Elangovan <elangog@wipinfo.soft.net>
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