Re: [HACKERS] Weird Grant/Revoke/Usage behavior

2005-12-06 Thread Tom Lane
Bruce Momjian writes: > Can someone comment on this? It's operating as designed. Schemas you don't have USAGE privilege on are ignored if listed in your search path. regards, tom lane ---(end of broadcast)--- TIP 1: if pos

Re: [HACKERS] Weird Grant/Revoke/Usage behavior

2005-12-06 Thread Bruce Momjian
Can someone comment on this? --- Joshua D. Drake wrote: > Hello, > > The below seems incorrect. If I am in the schema the behavior seems > correct. I can't see or select from the table. > However if I am not in the schema

[HACKERS] Weird Grant/Revoke/Usage behavior

2005-12-01 Thread Joshua D. Drake
Hello, The below seems incorrect. If I am in the schema the behavior seems correct. I can't see or select from the table. However if I am not in the schema I am able to see the table and its structure. The user jd is not a superuser. cleancontact=# revoke usage on schema financials from jd; R