dmmkstore工具使用
使用说明，dmmkstore使用分为以下步骤
1.用户准备
2.配置dm_svc.conf
3.创建wallet文件
4.创建凭据
5.查看凭据
6.DISQL使用服务名连接

Windows使用

1.不带@
create user "ABC123$//ABC" identified by "abc123$//ABC" password_policy 0;
grant "PUBLIC","SOI" to "ABC123$//ABC";

dmmkstore -wrl C:\Users\Administrator\Desktop\1 -create
abc123$//A

dmmkstore -wrl C:\Users\Administrator\Desktop\1 -createCredential abc123$//test ABC123$//ABC abc123$//ABC
abc123$//A

dmmkstore -wrl C:\Users\Administrator\Desktop\1 -listCredential
abc123$//A

WALLET_LOCATION=(C:\Users\Administrator\Desktop\1)
abc123$//test =(127.0.0.1:5236)

disql /@abc123$//test

2.带@
create user "ABC123$@//ABC" identified by "abc123$@//ABC" password_policy 0;
grant "PUBLIC","SOI" to "ABC123$@//ABC";

dmmkstore -wrl C:\Users\Administrator\Desktop\1 -create
abc123$@//A

dmmkstore -wrl C:\Users\Administrator\Desktop\1 -createCredential abc123$@//test ABC123$@//ABC abc123$@//ABC
abc123$@//A

dmmkstore -wrl C:\Users\Administrator\Desktop\1 -listCredential
abc123$@//A

WALLET_LOCATION=(C:\Users\Administrator\Desktop\1)
abc123$@//test =(127.0.0.1:5236)

disql /@"abc123$@//test"

Linux使用

1.不带@

create user "ABC123$//ABC" identified by "abc123$//ABC" password_policy 0;
grant "PUBLIC","SOI" to "ABC123$//ABC";

./dmmkstore -wrl /opt/dmdbms/dmmkstore -create
abc123$//A

./dmmkstore -wrl /opt/dmdbms/dmmkstore -createCredential abc123$//test ABC123$//ABC abc123$//ABC
abc123$//A

./dmmkstore -wrl /opt/dmdbms/dmmkstore -listCredential
abc123$//A

WALLET_LOCATION=(/opt/dmdbms/dmmkstore)
abc123$//test =(192.168.218.169:5236)

./disql /@abc123$//test

2.带@
create user "ABC123$/@ABC" identified by "abc123$/@ABC" password_policy 0;
grant "PUBLIC","SOI" to "ABC123$/@ABC";

./dmmkstore -wrl /opt/dmdbms/dmmkstore -create
abc123$/@A

./dmmkstore -wrl /opt/dmdbms/dmmkstore -createCredential abc123$/@test ABC123$/@ABC abc123$/@ABC
abc123$/@A

./dmmkstore -wrl /opt/dmdbms/dmmkstore -listCredential
abc123$/@A

WALLET_LOCATION=(/opt/dmdbms/dmmkstore)
abc123$/@test =(192.168.218.170:5236)

./disql '"ABC123$/@ABC"'/'"abc123$/@ABC"'@192.168.218.170:5236
./disql '"ABC123$/@ABC"'/'"abc123$/@ABC"'@'"abc123$/@test"'
./disql /@'"abc123$/@test"'

转义很重要，在使用达梦时特殊字符需要进行转义

在windows下，需要使用双引号将密码包含进来，同时对双引号使用\进行转移，具体例子如下：
disql SYSDBA/"abcd@efgh"@localhost

linux下，需要使用双引号将密码包含进来，同时外层再使用单引号进行转移，具体例子如下：
disql SYSDBA/'"abcd@efgh"'@localhost