Search Postgresql Archives

LISTEN filtering

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

 



-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


Quick idea to toss out there: allowing an option to LISTEN to 
only 'hear' from superusers (or self). I've got an app that uses a lot 
of listen/notify to talk to other subprocesses. However, it 
would be nice if non-superusers could not affect the behavior 
of this application: right now, anyone can issue a NOTIFY. (Yes, 
I can look information up about the calling notifier's PID, 
but that's not easy). Rather than a full 'rights' system (which 
would be complex overkill), what if we had an  option to LISTEN 
that said "I only want to hear notices coming from superusers"? 
Or perhaps an option that says "I only want to hear notices 
coming from me (same role)"? This would not affect notifications 
at all, but would simply act as a quick filter on incoming 
notices for a specific listener.

- -- 
Greg Sabino Mullane greg@xxxxxxxxxxxx
PGP Key: 0x14964AC8 201106211156
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk4Av1UACgkQvJuQZxSWSsgMKACgoM8de4sD0Hya0We2ncxmbsNE
eU0AnjWh8Iqhu8cGMaywGhtxs4rQ7HOh
=M7Ms
-----END PGP SIGNATURE-----



-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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 Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux