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
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
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
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
Bryan White [EMAIL PROTECTED] writes:
ec=# \z bulkuploadcfg
Access privileges for database ec
Schema | Table |Access privileges
+---+--
public |
Tom Lane wrote:
Bryan White [EMAIL PROTECTED] writes:
ec=# \z bulkuploadcfg
Access privileges for database ec
Schema | Table |Access privileges