Search Postgresql Archives

Re: Read only user permission

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hellen Jiang <hjiang@xxxxxxxxxxxxxxxxxxxxx> writes:
> I have created readonly and readwrite roles with the following grants: however, readonly user does not have access to the new tables created by readwrite user. (readonly user has the access to new tables created by admin).
> Any idea how I can grant the access to readonly to make sure it has the read access to NEW tables created by readwrite user?

The readwrite user (not the admin) would need to issue ALTER DEFAULT
PRIVILEGES granting that.

			regards, tom lane






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux