Tom Lane wrote:
Bryan White <[EMAIL PROTECTED]> writes:
ec=# \z bulkuploadcfg
Access privileges for database "ec"
Schema | Table |Access privileges
+---+
Bryan White <[EMAIL PROTECTED]> writes:
> ec=# \z bulkuploadcfg
> Access privileges for database "ec"
> Schema | Table |Access privileges
> +---+--
>
Tom Lane wrote:
You need to revoke them as that user, likely. REVOKE really means
"revoke grants I made", not "revoke any grant anybody made".
Ok I tried logging is as that user. Oddly after the revoke then only
grant that disappeared was one I created.
Maybe it has something to do with 'g
Vivek Khera <[EMAIL PROTECTED]> writes:
> not sure why you're not able to revoke permissions. that seems
> curious to me.
You need to revoke them as that user, likely. REVOKE really means
"revoke grants I made", not "revoke any grant anybody made".
regards, tom lane
-
On Mar 14, 2006, at 9:54 AM, Bryan White wrote:
How can I clean this up. Would dropping the user have any effect?
This is on 7.4 if that makes a difference.
dropping the user will leave dangling permissions (ie, Pg will report
them as being granted to user "103" or whatever Id that user h
I have a database that has a few tables that have privileges granted by
a user that no longer works here. I am the owner of these tables and
the owner of the database. If I do any granting/revoking on these
tables my actions do not seem to affect the privs set by this other
user. The privile