*** Create_Grants.sql
DEFINE EOwner='&1'
SET echo off feed off pages 0 verify off
SET lines 130
SPOOL Sqls/Create_Grants_RBPONL_&EOwner..sql
SELECT 'Grant '
|| DECODE (object_type,
'TABLE', 'select,insert,delete,update',
'SEQUENCE', 'select',
'VIEW', 'select,insert,delete,update',
'execute'
)
|| ' on '
|| UPPER ('&EOwner')
|| '.'
|| object_name
|| ' to &EOwner._USER;'
FROM dba_objects
WHERE owner = UPPER ('&EOwner')
AND object_type IN
('TABLE',
'SEQUENCE',
'VIEW',
'PACKAGE',
'PROCEDURE',
'FUNCTION',
'TYPE'
);
SPOOL off
exit;
*** Create_Synonyms.sql
DEFINE EOwner='&1'
SET echo off feed off pages 0 verify off
SET lines 200
SPOOL Sqls/Create_Synonyms_RBPONL_&EOwner..sql
SELECT 'Drop synonym '||d1.owner||'.'
|| synonym_name || ';'
FROM dba_synonyms d1,
( SELECT DISTINCT grantee FROM dba_role_privs
WHERE granted_role IN (upper('&EOwner._user'),upper('&EOwner._read'))
AND grantee NOT IN ('SYS')
) d2
WHERE d1.table_owner=UPPER ('&EOwner')
AND d1.owner=d2.grantee
AND (d1.table_owner, d1.table_name) not in
( SELECT owner, object_name from dba_objects
WHERE object_type IN ('FUNCTION', 'PACKAGE BODY', 'PROCEDURE', 'SEQUENCE', 'TABLE', 'TYPE', 'VIEW')
AND owner = UPPER ('&EOwner'))
UNION ALL
SELECT 'Create synonym '||d2.grantee||'.'
|| d1.object_name
|| ' for &EOwner..'
|| d1.object_name
|| ';'
FROM dba_objects d1,
( SELECT DISTINCT grantee FROM dba_role_privs
WHERE granted_role IN (upper('&EOwner._user'),upper('&EOwner._read'))
AND grantee NOT IN ('SYS')
) d2
WHERE d1.object_type IN ('FUNCTION', 'PACKAGE BODY', 'PROCEDURE', 'SEQUENCE', 'TABLE', 'TYPE', 'VIEW')
AND d1.owner = UPPER ('&EOwner')
AND (d2.grantee,d1.object_name) not in
( SELECT owner, synonym_name from dba_synonyms
WHERE table_owner=UPPER ('&EOwner') )
;
SPOOL off
REM **************************************** END OF FILE ************************************************
exit;
*** Run_Grants.sql
DEFINE EOwner='&1'
SET echo off feed off pages 0 verify off
SET lines 130
SET feed on echo on
SPOOL Logs/Create_Grants_RBPONL_&EOwner..log
START Sqls/Create_Grants_RBPONL_&EOwner..sql
SPOOL off
exit;
*** Run_Synonyms.sql
DEFINE EAppUser='&1'
SET echo off feed off pages 0 verify off
SET lines 200
SET echo on feed on
SPOOL Logs/Create_Synonyms_RBPONL_&EAppUser..log
START Sqls/Create_Synonyms_RBPONL_&EAppUser..sql
SPOOL off
REM **************************************** END OF FILE ************************************************
exit;
调用程序:
cd %~dp0
set ORACLE_HOME=C:\ORACLE\ORACLE_1120\product\11.2.0\client_1
set SCHEMA_NAME=schema_name
set PASSWORD=password
set DB_NAME=db_name
%ORACLE_HOME%/bin/sqlplus %SCHEMA_NAME%/%PASSWORD%@%DB_NAME% @goldstack/Create_Grants.sql %SCHEMA_NAME%
%ORACLE_HOME%/bin/sqlplus %SCHEMA_NAME%/%PASSWORD%@%DB_NAME% @goldstack/Run_Grants.sql %SCHEMA_NAME%
%ORACLE_HOME%/bin/sqlplus %SCHEMA_NAME%/%PASSWORD%@%DB_NAME% @goldstack/Create_Synonyms.sql %SCHEMA_NAME%
findstr "APPUSER" Sqls\Create_Synonyms_RBPONL_%SCHEMA_NAME%.sql > Sqls\Create_Synonyms_RBPONL_%SCHEMA_NAME%_APPUSER.sql
%ORACLE_HOME%/bin/sqlplus %SCHEMA_NAME%_APPUSER/%PASSWORD%@%DB_NAME% @goldstack/Run_Synonyms.sql %SCHEMA_NAME%_APPUSER
分享到:
相关推荐
作者自己编译的同义词插件版本为7.12.1,欢迎大家学校交流
elasticsearch同义词插件,基于数据库的热加载,可以实现从数据库实时查询分词,支持mysql和oracle两种数据库,只需要将插件解压到ES安装目录下的插件目录下即可,解压之后删除安装包
资源分类:Python库 所属语言:Python 资源全名:synonym_dict-0.1.2-py3-none-any.whl 资源来源:官方 安装方法:https://lanzao.blog.csdn.net/article/details/101784059
elasticsearch-analysis-dynamic-synonym7.5.1版本 Elasticsearch 使用同义词插件
语言:English 搜索Google定义和Web定义,在新标签页中打开结果。 搜索Google定义和Web定义,在新标签页中打开结果。
ELASTICSEARCH7.6.2 动态同义词/近义词动态加载同义词/近义词 DYNAMIC_SYNONYM
最新中文近义词大全,seo等
elasticsearch-analysis-dynamic-synonym-6.2.4 想重新定义的话可到仓库留言 https://gitee.com/lumou/elasticsearch-analysis-dynamic-synonym 原...
python库。 资源全名:synonym-0.1.3-py2.py3-none-any.whl
语言:English 词库:添加到右键单击菜单(+城市字典) *突出显示它们的同义词 **没有广告,没有跟踪,并且没有混乱地添加到浏览器中 新:+修复了所有报告的错误 +单击同义词以替换所选单词 这个令人敬畏的词库扩展...
NULL 博文链接:https://sunruing.iteye.com/blog/1611276
插件地址 https://github.com/bells/elasticsearch-analysis-dynamic-synonym
官方的还是5.1.1版本,这里就根据官方的版本修改了一下,elasticsearch-analysis-dynamic-synonym-5.2.1,希望对需要的朋友有用 文章地址 http://write.blog.csdn.net/mdeditor#!postId=56845892
插件地址 https://github.com/bells/elasticsearch-analysis-dynamic-synonym
同义词挖掘一般有三种思路,借助已有知识库,上下文相关性,文本相似度。该zip包实现了4种同义词挖掘的方法:百度百科同义词,word2vector,语义共现网络的节点相似度,Levenshtein距离。感兴趣的同学可以下载下来...
语言:English control-f,它也通过同义词进行搜索。 ctrl-f,它也适用于同义词! 曾经想在页面中没有确切的单词,但其他单词也是如此吗? 没有进一步看。 一个非常简单的实用程序,可以在页面中找到所有类似的单词...
Elasticsearch同义词远程概述Elasticsearch同义词远程插件提供file_remote_synonym过滤器版本版本弹性搜索掌握1.7.1 1.0.0 1.7.1安装$ $ES_HOME/bin/plugin --install elasticsearch-synonym-remote --url file:\/\/...
教程地址:https://blog.csdn.net/Extraordinarylife/article/details/109601858 ElasticSearch IK 动态同义词/近义词动态加载同义词/近义词