cool hit counter Handling of expired user passwords_Intefrankly

Handling of expired user passwords


1.windows environment

1.1 Turn on the database service

1.1.1 In windows environment, find DmServiceDMSERVER directly in the service and open it

1.1.2 Command line method: dmserver.exeh:dmdbmsdataDAMENGdm.ini

1.2 Use the SYSDBA system administrator user to log in to the database because the user password has expired

1.2.1 Recommend to use the management tool directly, double click on it

1.2.2 Command line method: dISQLSYSDBA/SYSDBA@localhost

1.3 Reset the password for users whose passwords have expired, as shown in the following example

--execute sql statements directly from within the Administration tool

alter user "DMDBA" identifiedby "DMDBA_12345";

1.4 Sometimes passwords contain special characters such as @ that prevent dISQL from connecting and running directly. It needs to be handled by a transfer character. The disql escape character is used as follows

--In windows, the password needs to be included using double quotes, while transferring the use of double quotes, as in the following example.

disqlSYSDBA/"abcd@efgh"@localhost

2.under linux environment

2.1 Turn on the database service

[dmdba@localhost Desktop]$ cd/home/dmdba/dmdbms/bin

[dmdba@localhost bin]$ ./dmserver/home/dmdba/dmdbms/data/DAMENG/dm.ini

file dm.key not found, use defaultlicense!

version info: develop

Use normal os_malloc instead of HugeTLB

Use normal os_malloc instead of HugeTLB

DM Database Server x64V7.1.5.158-Build(2017.02.13-77698)ENT startup...

License will expire on 2018-02-13

ckpt lsn: 57014

iid page's trxid = 1794

NEXT TRX ID = 1795

SYSTEM IS READY.

If SYSTEMIS READY is displayed, the database service is started successfully

2.2 Use the SYSDBA system administrator user to log in to the database because the user password has expired

[dmdba@localhost bin]$ ./disqlSYSDBA/SYSDBA@localhost

Server[localhost:5236]:mode is normal,state is open

login used time: 26.201(ms)

disqlV7.1.5.158-Build(2017.02.13-77698)ENT

Connected to: DM 7.1.5.158

2.3 Reset the password for users whose passwords have expired, as shown in the following example

SQL>alter user "DMDBA"identified by "DMDBA_12345"; //Fill in the new password

2.4 Sometimes passwords contain special characters such as @ causing disql to not connect and run directly. It needs to be handled by a transfer character. The disql escape character is used as follows

--linux, the password needs to be included using double quotes, while the outer layer is then transferred using single quotes, as in the following example.

[dmdba@localhost bin]$ ./disqlDBATEST/'"abcd@efgh"'@localhost


Recommended>>
1、Kotlins oneofakind secret Reified actualization type parameter
2、AI pioneer one day machines could think like humans
3、Where do we go with our emotions when the age of artificial intelligence dawns
4、Most Popular Python Projects on GitHub in December
5、Big Data 2017 ranked Jiangsu third in the country for buying books

    已推荐到看一看 和朋友分享想法
    最多200字,当前共 发送

    已发送

    朋友将在看一看看到

    确定
    分享你的想法...
    取消

    分享想法到看一看

    确定
    最多200字,当前共

    发送中

    网络异常,请稍后重试

    微信扫一扫
    关注该公众号