pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Problem 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