insert into sys.link$ (OWNER#, NAME, CTIME, HOST, USERID, PASSWORD, FLAG, AUTHUSR, AUTHPWD, PASSWORDX, AUTHPWDX)
SELECT user_id
,'DB_LINK_NAME'
,SYSDATE
,'CONNECTION_STRING',
'TARGET_DATABASE_USERNAME',
null, '2', null, NULL
,'hashed password can be extracted from sys.link$.PASSWORDX'
, NULL
FROM dba_users
WHERE username = 'LINK_OWNER' -- DB link owner
Комментариев нет:
Отправить комментарий