特色理念 [英] Feature idea
问题描述
如果SET SESSION AUTHORIZATION也可以接受密码，以便非
超级用户可以切换到其他用户怎么办？这有多难？
一个不错的附带好处就是你可以在mod perl下有效地连接许多用户和Apache :: DBI没有开放的连接
为每个用户。
克里斯
------------ ---------------（播出结束）---------------------------
提示2：您可以使用取消注册命令一次性取消所有列表
（发送取消注册YourEmailAddressHere到 ma ******* @ postgresql.org ）
What if SET SESSION AUTHORIZATION could also accept a password so that non
superusers could switch to a different user? How difficult would this be?
One nice side benefit to this would be that you could effectively connect as
many users with Apache::DBI under mod perl without having an open connection
for every user.
Chris
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)
推荐答案
Chris Ochs写道：
Chris Ochs wrote:
如果SET SESSION AUTHORIZATION也可以接受密码，那么非
超级用户可以切换到不同的用户怎么办？这有多难？
What if SET SESSION AUTHORIZATION could also accept a password so that non
superusers could switch to a different user? How difficult would this be?
好吧，密码将通过未加密的电线，导致
安全问题。
-
Bruce Momjian | http://candle.pha.pa.us
pg *** @ candle.pha.pa.us | （610）359-1001
+如果你的生活是硬盘，|罗伯茨路13号
+基督可以成为你的备份。 |宾夕法尼亚州新城广场19073年
---------------------------（播出结束） - --------------------------
提示5：您查看了我们广泛的常见问题解答吗？
http://www.postgresql.org/docs/faqs/ FAQ.html
Well, the password would go over the wire unencrypted, causing a
security problem.
--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Chris Ochs写道：
Chris Ochs wrote:
如果SET SESSION AUTHORIZATION也可以接受密码，以便非超级用户可以切换到不同的用户？这有多难？
What if SET SESSION AUTHORIZATION could also accept a password so that non
superusers could switch to a different user? How difficult would this be?
好吧，密码将通过未加密的电线，导致
安全问题。
-
Bruce Momjian | http://candle.pha.pa.us
pg *** @ candle.pha.pa.us | （610）359-1001
+如果你的生活是硬盘，|罗伯茨路13号
+基督可以成为你的备份。 |宾夕法尼亚州新城广场19073年
---------------------------（播出结束） - --------------------------
提示5：您查看了我们广泛的常见问题解答吗？
http://www.postgresql.org/docs/faqs/ FAQ.html
Well, the password would go over the wire unencrypted, causing a
security problem.
--
Bruce Momjian | http://candle.pha.pa.us
pg***@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Bruce Momjian< pg *** @ candle.pha.pa.us>写道：
Bruce Momjian <pg***@candle.pha.pa.us> wrote:
Chris Ochs写道：
Chris Ochs wrote:
如果SET SESSION AUTHORIZATION也可以接受密码，那么非
超级用户可以切换给不同的用户？这有多难？
What if SET SESSION AUTHORIZATION could also accept a password so that non
superusers could switch to a different user? How difficult would this be?
嗯，密码将通过未加密的电线，导致安全问题。
Well, the password would go over the wire unencrypted, causing a
security problem.
仅当未启用加密传输时。使用加密传输，它会像其他任何东西一样安全，对吗？
也许，它只有在启用传输加密时才可用？然后再次获得
，有一定数量的只有用户才可以拍自己的脚。那个
必须被接受...
只是大声思考......
-
Bill Moran
潜在技术
http ：//www.potentialtech.com
-------------------------- - （广播结束）---------------------------
提示9：规划师会忽略你的欲望如果您的
加入列的数据类型不匹配，请选择索引扫描
Only if encrypted transport is not enabled. With encrypted transport, it would
be as secure as anything else, right?
Perhaps, it could only be available if transmission encryption is enabled? Then
again, there''s a certain amount of "only the user can shoot his own foot" that
has to be accepted ...
Just thinking out loud ...
--
Bill Moran
Potential Technologies
http://www.potentialtech.com
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column''s datatypes do not match
这篇关于特色理念的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
