[pgcluster: 32] regress test (privilege. sql)実行結果(抜粋)およびスタンドアロン確認結果送付の件

[kokamoto ＠ itg.hitachi.co.jp]

--GMAILSMTPBOUND01040114152413
Content-Type: text/plain; charset=ISO-2022-JP

岡本です。お世話になります。

regress test (privilege.sql)の実行結果を送ります。
このテストの中で作成した regressuser3のアクセス権限が
シングルサーバの時(oss239）とは異なってしまうため、
実行結果が異なってしまうようです。
作成されたユーザの詳細情報を調査する方法が良くわからないので
これ以上つっこんだ調査が出来ませんでした。

--
岡本　一幸
（株）日立製作所
プラットフォームシステムソリューション本部（PSS本）
共通技術プラットフォームＳＩ部（共通PSI）Ｌｉｎｕｘビジネス推進センタ(LxG)


--GMAILSMTPBOUND01040114152413
Content-Type: application/octet-stream; 
	name="oss242_privilege.txt"
Content-Disposition: attachment; 
	filename="oss242_privilege.txt"
Content-Transfer-Encoding: base64

cmVncmVzc2lvbj0jIFxjIC0NCllvdSBhcmUgbm93IGNvbm5lY3RlZCB0byBkYXRhYmFzZSBy
ZWdyZXNzaW9uLg0KcmVncmVzc2lvbj0jIFNFVCBhdXRvY29tbWl0IFRPICdvbic7DQpTRVQN
CnJlZ3Jlc3Npb249IyBzZWxlY3QgaGFzX3RhYmxlX3ByaXZpbGVnZShjdXJyZW50X3VzZXIs
J3BnX3NoYWRvdycsJ3NlbGVjdCcpOw0KIGhhc190YWJsZV9wcml2aWxlZ2UNCi0tLS0tLS0t
LS0tLS0tLS0tLS0tLQ0KIHQNCigxIHJvdykNCg0KcmVncmVzc2lvbj0jIHNlbGVjdCBoYXNf
dGFibGVfcHJpdmlsZWdlKGN1cnJlbnRfdXNlciwncGdfc2hhZG93JywnaW5zZXJ0Jyk7DQog
aGFzX3RhYmxlX3ByaXZpbGVnZQ0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogdA0KKDEgcm93
KQ0KDQpyZWdyZXNzaW9uPSMgc2VsZWN0IGhhc190YWJsZV9wcml2aWxlZ2UodDIudXNlc3lz
aWQsJ3BnX3NoYWRvdycsJ3VwZGF0ZScpDQpyZWdyZXNzaW9uLSMgZnJvbSAoc2VsZWN0IHVz
ZXN5c2lkIGZyb20gcGdfdXNlciB3aGVyZSB1c2VuYW1lID0gY3VycmVudF91c2VyKSBhcyB0
MjsNCiBoYXNfdGFibGVfcHJpdmlsZWdlDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiB0DQoo
MSByb3cpDQoNCnJlZ3Jlc3Npb249IyBzZWxlY3QgaGFzX3RhYmxlX3ByaXZpbGVnZSh0Mi51
c2VzeXNpZCwncGdfc2hhZG93JywnZGVsZXRlJykNCnJlZ3Jlc3Npb24tIyBmcm9tIChzZWxl
Y3QgdXNlc3lzaWQgZnJvbSBwZ191c2VyIHdoZXJlIHVzZW5hbWUgPSBjdXJyZW50X3VzZXIp
IGFzIHQyOw0KIGhhc190YWJsZV9wcml2aWxlZ2UNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0K
IHQNCigxIHJvdykNCg0KcmVncmVzc2lvbj0jIHNlbGVjdCBoYXNfdGFibGVfcHJpdmlsZWdl
KGN1cnJlbnRfdXNlcix0MS5vaWQsJ3J1bGUnKQ0KcmVncmVzc2lvbi0jIGZyb20gKHNlbGVj
dCBvaWQgZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxuYW1lID0gJ3BnX3NoYWRvdycpIGFzIHQx
Ow0KIGhhc190YWJsZV9wcml2aWxlZ2UNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIHQNCigx
IHJvdykNCg0KcmVncmVzc2lvbj0jIHNlbGVjdCBoYXNfdGFibGVfcHJpdmlsZWdlKGN1cnJl
bnRfdXNlcix0MS5vaWQsJ3JlZmVyZW5jZXMnKQ0KcmVncmVzc2lvbi0jIGZyb20gKHNlbGVj
dCBvaWQgZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxuYW1lID0gJ3BnX3NoYWRvdycpIGFzIHQx
Ow0KIGhhc190YWJsZV9wcml2aWxlZ2UNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIHQNCigx
IHJvdykNCg0KcmVncmVzc2lvbj0jIHNlbGVjdCBoYXNfdGFibGVfcHJpdmlsZWdlKHQyLnVz
ZXN5c2lkLHQxLm9pZCwnc2VsZWN0JykNCnJlZ3Jlc3Npb24tIyBmcm9tIChzZWxlY3Qgb2lk
IGZyb20gcGdfY2xhc3Mgd2hlcmUgcmVsbmFtZSA9ICdwZ19zaGFkb3cnKSBhcyB0MSwNCnJl
Z3Jlc3Npb24tIyAgIChzZWxlY3QgdXNlc3lzaWQgZnJvbSBwZ191c2VyIHdoZXJlIHVzZW5h
bWUgPSBjdXJyZW50X3VzZXIpIGFzIHQyOw0KIGhhc190YWJsZV9wcml2aWxlZ2UNCi0tLS0t
LS0tLS0tLS0tLS0tLS0tLQ0KIHQNCigxIHJvdykNCg0KcmVncmVzc2lvbj0jIHNlbGVjdCBo
YXNfdGFibGVfcHJpdmlsZWdlKHQyLnVzZXN5c2lkLHQxLm9pZCwnaW5zZXJ0JykNCnJlZ3Jl
c3Npb24tIyBmcm9tIChzZWxlY3Qgb2lkIGZyb20gcGdfY2xhc3Mgd2hlcmUgcmVsbmFtZSA9
ICdwZ19zaGFkb3cnKSBhcyB0MSwNCnJlZ3Jlc3Npb24tIyAgIChzZWxlY3QgdXNlc3lzaWQg
ZnJvbSBwZ191c2VyIHdoZXJlIHVzZW5hbWUgPSBjdXJyZW50X3VzZXIpIGFzIHQyOw0KIGhh
c190YWJsZV9wcml2aWxlZ2UNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIHQNCigxIHJvdykN
Cg0KcmVncmVzc2lvbj0jIHNlbGVjdCBoYXNfdGFibGVfcHJpdmlsZWdlKCdwZ19zaGFkb3cn
LCd1cGRhdGUnKTsNCiBoYXNfdGFibGVfcHJpdmlsZWdlDQotLS0tLS0tLS0tLS0tLS0tLS0t
LS0NCiB0DQooMSByb3cpDQoNCnJlZ3Jlc3Npb249IyBzZWxlY3QgaGFzX3RhYmxlX3ByaXZp
bGVnZSgncGdfc2hhZG93JywnZGVsZXRlJyk7DQogaGFzX3RhYmxlX3ByaXZpbGVnZQ0KLS0t
LS0tLS0tLS0tLS0tLS0tLS0tDQogdA0KKDEgcm93KQ0KDQpyZWdyZXNzaW9uPSMgc2VsZWN0
IGhhc190YWJsZV9wcml2aWxlZ2UodDEub2lkLCdzZWxlY3QnKQ0KcmVncmVzc2lvbi0jIGZy
b20gKHNlbGVjdCBvaWQgZnJvbSBwZ19jbGFzcyB3aGVyZSByZWxuYW1lID0gJ3BnX3NoYWRv
dycpIGFzIHQxOw0KIGhhc190YWJsZV9wcml2aWxlZ2UNCi0tLS0tLS0tLS0tLS0tLS0tLS0t
LQ0KIHQNCigxIHJvdykNCg0KcmVncmVzc2lvbj0jIHNlbGVjdCBoYXNfdGFibGVfcHJpdmls
ZWdlKHQxLm9pZCwndHJpZ2dlcicpDQpyZWdyZXNzaW9uLSMgZnJvbSAoc2VsZWN0IG9pZCBm
cm9tIHBnX2NsYXNzIHdoZXJlIHJlbG5hbWUgPSAncGdfc2hhZG93JykgYXMgdDE7DQogaGFz
X3RhYmxlX3ByaXZpbGVnZQ0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogdA0KKDEgcm93KQ0K
DQpyZWdyZXNzaW9uPSMgU0VUIFNFU1NJT04gQVVUSE9SSVpBVElPTiByZWdyZXNzdXNlcjM7
DQpTRVQNCnJlZ3Jlc3Npb249IyBzZWxlY3QgaGFzX3RhYmxlX3ByaXZpbGVnZShjdXJyZW50
X3VzZXIsJ3BnX2NsYXNzJywnc2VsZWN0Jyk7DQogaGFzX3RhYmxlX3ByaXZpbGVnZQ0KLS0t
LS0tLS0tLS0tLS0tLS0tLS0tDQogZg0KKDEgcm93KQ0KDQpyZWdyZXNzaW9uPSMNCg==

--GMAILSMTPBOUND01040114152413
Content-Type: application/octet-stream; 
	name="oss239_has_table_privilege.txt"
Content-Disposition: attachment; 
	filename="oss239_has_table_privilege.txt"
Content-Transfer-Encoding: base64

W3Bvc3RncmVzQG9zczIzOSBwZ3NxbF0kIHBzcWwgLWggbG9jYWxob3N0IHJlZ3Jlc3Npb24N
CldlbGNvbWUgdG8gcHNxbCA3LjMuNC1SSCwgdGhlIFBvc3RncmVTUUwgaW50ZXJhY3RpdmUg
dGVybWluYWwuDQoNClR5cGU6ICBcY29weXJpZ2h0IGZvciBkaXN0cmlidXRpb24gdGVybXMN
CiAgICAgICBcaCBmb3IgaGVscCB3aXRoIFNRTCBjb21tYW5kcw0KICAgICAgIFw/IGZvciBo
ZWxwIG9uIGludGVybmFsIHNsYXNoIGNvbW1hbmRzDQogICAgICAgXGcgb3IgdGVybWluYXRl
IHdpdGggc2VtaWNvbG9uIHRvIGV4ZWN1dGUgcXVlcnkNCiAgICAgICBccSB0byBxdWl0DQoN
CnJlZ3Jlc3Npb249IyBDUkVBVEUgVVNFUiByZWdyZXNzdXNlcjE7DQpDUkVBVEUgVVNFUg0K
cmVncmVzc2lvbj0jIENSRUFURSBVU0VSIHJlZ3Jlc3N1c2VyMjsNCkNSRUFURSBVU0VSDQpy
ZWdyZXNzaW9uPSMgQ1JFQVRFIFVTRVIgcmVncmVzc3VzZXIzOw0KQ1JFQVRFIFVTRVINCnJl
Z3Jlc3Npb249IyBDUkVBVEUgVVNFUiByZWdyZXNzdXNlcjQ7DQpDUkVBVEUgVVNFUg0KcmVn
cmVzc2lvbj0jIENSRUFURSBHUk9VUCByZWdyZXNzZ3JvdXAxOw0KQ1JFQVRFIEdST1VQDQpy
ZWdyZXNzaW9uPSMgQ1JFQVRFIEdST1VQIHJlZ3Jlc3Nncm91cDIgV0lUSCBVU0VSIHJlZ3Jl
c3N1c2VyMSwgcmVncmVzc3VzZXIyOw0KQ1JFQVRFIEdST1VQDQpyZWdyZXNzaW9uPSMgQUxU
RVIgR1JPVVAgcmVncmVzc2dyb3VwMSBBREQgVVNFUiByZWdyZXNzdXNlcjQ7DQpBTFRFUiBH
Uk9VUA0KcmVncmVzc2lvbj0jIEFMVEVSIEdST1VQIHJlZ3Jlc3Nncm91cDIgRFJPUCBVU0VS
IHJlZ3Jlc3N1c2VyMjsNCkFMVEVSIEdST1VQDQpyZWdyZXNzaW9uPSMgQUxURVIgR1JPVVAg
cmVncmVzc2dyb3VwMiBBREQgVVNFUiByZWdyZXNzdXNlcjQ7DQpBTFRFUiBHUk9VUA0KcmVn
cmVzc2lvbj0jIFNFTEVDVCBzZXNzaW9uX3VzZXIsIGN1cnJlbnRfdXNlcjsNCiBzZXNzaW9u
X3VzZXIgfCBjdXJyZW50X3VzZXINCi0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tDQog
cG9zdGdyZXMgICAgIHwgcG9zdGdyZXMNCigxIHJvdykNCg0KcmVncmVzc2lvbj0jIFx6IHBn
X2NsYXNzDQpBY2Nlc3MgcHJpdmlsZWdlcyBmb3IgZGF0YWJhc2UgInJlZ3Jlc3Npb24iDQog
U2NoZW1hIHwgVGFibGUgfCBBY2Nlc3MgcHJpdmlsZWdlcw0KLS0tLS0tLS0rLS0tLS0tLSst
LS0tLS0tLS0tLS0tLS0tLS0tDQooMCByb3dzKQ0KDQpyZWdyZXNzaW9uPSMgc2VsZWN0IGhh
c190YWJsZV9wcml2aWxlZ2UoY3VycmVudF91c2VyLCdwZ19jbGFzcycsJ3NlbGVjdCcpOw0K
IGhhc190YWJsZV9wcml2aWxlZ2UNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIHQNCigxIHJv
dykNCg0KcmVncmVzc2lvbj0jIFNFVCBTRVNTSU9OIEFVVEhPUklaQVRJT04gcmVncmVzc3Vz
ZXIzOw0KU0VUDQpyZWdyZXNzaW9uPSMgU0VMRUNUIHNlc3Npb25fdXNlciwgY3VycmVudF91
c2VyOw0KIHNlc3Npb25fdXNlciB8IGN1cnJlbnRfdXNlcg0KLS0tLS0tLS0tLS0tLS0rLS0t
LS0tLS0tLS0tLS0NCiByZWdyZXNzdXNlcjMgfCByZWdyZXNzdXNlcjMNCigxIHJvdykNCg0K
cmVncmVzc2lvbj0jIFx6IHBnX2NsYXNzDQpBY2Nlc3MgcHJpdmlsZWdlcyBmb3IgZGF0YWJh
c2UgInJlZ3Jlc3Npb24iDQogU2NoZW1hIHwgVGFibGUgfCBBY2Nlc3MgcHJpdmlsZWdlcw0K
LS0tLS0tLS0rLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tDQooMCByb3dzKQ0KDQpyZWdy
ZXNzaW9uPSMgc2VsZWN0IGhhc190YWJsZV9wcml2aWxlZ2UoY3VycmVudF91c2VyLCdwZ19j
bGFzcycsJ3NlbGVjdCcpOw0KIGhhc190YWJsZV9wcml2aWxlZ2UNCi0tLS0tLS0tLS0tLS0t
LS0tLS0tLQ0KIHQNCigxIHJvdykNCg0KcmVncmVzc2lvbj0jDQo=

--GMAILSMTPBOUND01040114152413
Content-Type: application/octet-stream; 
	name="oss242_has_table_privilege.txt"
Content-Disposition: attachment; 
	filename="oss242_has_table_privilege.txt"
Content-Transfer-Encoding: base64

W3Bvc3RncmVzQG9zczI0MiBwZ3NxbF0kIHBzcWwgLWggbG9jYWxob3N0IHJlZ3Jlc3Npb24N
CldlbGNvbWUgdG8gcHNxbCA3LjMuNC1SSCwgdGhlIFBvc3RncmVTUUwgaW50ZXJhY3RpdmUg
dGVybWluYWwuDQoNClR5cGU6ICBcY29weXJpZ2h0IGZvciBkaXN0cmlidXRpb24gdGVybXMN
CiAgICAgICBcaCBmb3IgaGVscCB3aXRoIFNRTCBjb21tYW5kcw0KICAgICAgIFw/IGZvciBo
ZWxwIG9uIGludGVybmFsIHNsYXNoIGNvbW1hbmRzDQogICAgICAgXGcgb3IgdGVybWluYXRl
IHdpdGggc2VtaWNvbG9uIHRvIGV4ZWN1dGUgcXVlcnkNCiAgICAgICBccSB0byBxdWl0DQoN
CnJlZ3Jlc3Npb249IyBDUkVBVEUgVVNFUiByZWdyZXNzdXNlcjE7DQpDUkVBVEUgVVNFUg0K
cmVncmVzc2lvbj0jIENSRUFURSBVU0VSIHJlZ3Jlc3N1c2VyMjsNCkNSRUFURSBVU0VSDQpy
ZWdyZXNzaW9uPSMgQ1JFQVRFIFVTRVIgcmVncmVzc3VzZXIzOw0KQ1JFQVRFIFVTRVINCnJl
Z3Jlc3Npb249IyBDUkVBVEUgVVNFUiByZWdyZXNzdXNlcjQ7DQpDUkVBVEUgVVNFUg0KcmVn
cmVzc2lvbj0jIENSRUFURSBHUk9VUCByZWdyZXNzZ3JvdXAxOw0KQ1JFQVRFIEdST1VQDQpy
ZWdyZXNzaW9uPSMgQ1JFQVRFIEdST1VQIHJlZ3Jlc3Nncm91cDIgV0lUSCBVU0VSIHJlZ3Jl
c3N1c2VyMSwgcmVncmVzc3VzZXIyOw0KQ1JFQVRFIEdST1VQDQpyZWdyZXNzaW9uPSMgQUxU
RVIgR1JPVVAgcmVncmVzc2dyb3VwMSBBREQgVVNFUiByZWdyZXNzdXNlcjQ7DQpBTFRFUiBH
Uk9VUA0KcmVncmVzc2lvbj0jIEFMVEVSIEdST1VQIHJlZ3Jlc3Nncm91cDIgRFJPUCBVU0VS
IHJlZ3Jlc3N1c2VyMjsNCkFMVEVSIEdST1VQDQpyZWdyZXNzaW9uPSMgQUxURVIgR1JPVVAg
cmVncmVzc2dyb3VwMiBBREQgVVNFUiByZWdyZXNzdXNlcjQ7DQpBTFRFUiBHUk9VUA0KcmVn
cmVzc2lvbj0jIFNFTEVDVCBzZXNzaW9uX3VzZXIsIGN1cnJlbnRfdXNlcjsNCiBzZXNzaW9u
X3VzZXIgfCBjdXJyZW50X3VzZXINCi0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tDQog
cG9zdGdyZXMgICAgIHwgcG9zdGdyZXMNCigxIHJvdykNCg0KcmVncmVzc2lvbj0jICBceiBw
Z19jbGFzcw0KQWNjZXNzIHByaXZpbGVnZXMgZm9yIGRhdGFiYXNlICJyZWdyZXNzaW9uIg0K
IFNjaGVtYSB8IFRhYmxlIHwgQWNjZXNzIHByaXZpbGVnZXMNCi0tLS0tLS0tKy0tLS0tLS0r
LS0tLS0tLS0tLS0tLS0tLS0tLQ0KKDAgcm93cykNCg0KcmVncmVzc2lvbj0jIHNlbGVjdCBo
YXNfdGFibGVfcHJpdmlsZWdlKGN1cnJlbnRfdXNlciwncGdfY2xhc3MnLCdzZWxlY3QnKTsN
CiBoYXNfdGFibGVfcHJpdmlsZWdlDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiB0DQooMSBy
b3cpDQoNCnJlZ3Jlc3Npb249IyBTRVQgU0VTU0lPTiBBVVRIT1JJWkFUSU9OIHJlZ3Jlc3N1
c2VyMzsNClNFVA0KcmVncmVzc2lvbj0jIFNFTEVDVCBzZXNzaW9uX3VzZXIsIGN1cnJlbnRf
dXNlcjsNCiBzZXNzaW9uX3VzZXIgfCBjdXJyZW50X3VzZXINCi0tLS0tLS0tLS0tLS0tKy0t
LS0tLS0tLS0tLS0tDQogcmVncmVzc3VzZXIzIHwgcmVncmVzc3VzZXIzDQooMSByb3cpDQoN
CnJlZ3Jlc3Npb249IyBceiBwZ19jbGFzcw0KRVJST1I6ICBwZ19jbGFzczogcGVybWlzc2lv
biBkZW5pZWQNCnJlZ3Jlc3Npb249IyBzZWxlY3QgaGFzX3RhYmxlX3ByaXZpbGVnZShjdXJy
ZW50X3VzZXIsJ3BnX2NsYXNzJywnc2VsZWN0Jyk7DQogaGFzX3RhYmxlX3ByaXZpbGVnZQ0K
LS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogZg0KKDEgcm93KQ0KDQpyZWdyZXNzaW9uPSMNCg==

--GMAILSMTPBOUND01040114152413--