oracle synonyms

kobe_1980 2008-01-18 12:48:03

数据库画板
server:kobe
logid: hgh
logpass:hgh
catalog table owner:hgh
其他用默认的 ,pb9.0的profile
---------
pl/sql
server:kobe
logid: hgh
logpass:hgh
----------
sqlplus
id: hgh
password:hgh
string:kobe
--------------------------
table里面的表都一样
PB数据库画板的Synonyms与PL/SQL和sqlplus的Synonyms部分同义词不一样，我在PL/SQL编辑PB数据库画板没有的同义词时，在“转换”-“对象名称”的列表上找不到这个对象

...全文

298 6 打赏收藏转发到动态举报

写回复

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

knowledge_Is_Life 2008-04-30

打赏
举报

回复

我也想知道，正在找這方面的資料~~~~~

_liangzi_ 2008-01-29

打赏
举报

回复

我试了下没遇到你说的情况，可能是你PB9的问题

kobe_1980 2008-01-23

打赏
举报

回复

我看了一下只要PL/SQL 的synonym-"属性"中的“reference-type”这个属性的值是UNDEFINED，在PB里就看不到，为table的就可以. 这个属性作用是什么，怎么修改呀？

I_am_Z 2008-01-22

打赏
举报

回复

没遇到过，帮顶。

kobe_1980 2008-01-22

打赏
举报

回复

不是的，比如dj_dnjlbk这个同义词，在PL/SQL、sqlplus、powerdesigner的同义词集合里都能找的到，编辑的时候显示owner :hgh tableowner:kxf.在PB的数据库画板里根本找不到这个同义词，在程序里用 select * from dj_dnjlbk会提示找不到表或视图。
没有人碰到过这问题吗？

AFIC 2008-01-18

打赏
举报

回复

public的吧，Synonyms文件夹上点右键，show system Synonyms

Oracle的同义词（synonyms）总结

authors: Marlene Theriault William Heney Publisher: O'Reilly First Edition October 1998 （目录） Security in an oracle System Chapter 1 Oracle and Security What’s It All About? The Oracle Security Model Procedures, Policies, and Plans If I Had a Hammer... Chapter 2 Oracle System Files What’s in the Files? The Instance and the Database: Starting an Oracle Database Types of Database Files Chapter 3 Oracle Database Objects The User Interface: User Versus Schema Objects Tables Table Triggers Views Stored Programs Synonyms Privileges Roles Profiles Chapter 4 The Oracle Data Dictionary Creating and Maintaining the Data Dictionary The Data Dictionary Views About SQL.BSQ Views Used for Security The Composition of the Views Chapter 5 Oracle Default Roles and User Accounts About the Defaults The CONNECT Role The RESOURCE Role The DBA Role The SYSDBA and SYSOPER Roles Using the Default Roles Default User Accounts Segmenting Authority in the Database Chapter 6 Profiles, Passwords, and Synonyms Profiles Passwords Synonyms Implementing Security Chapter 7 Developing a Database Security Plan About the Security Policy and Security Plan Types of Accounts Standards for Accounts Standards for Usernames Standards for Passwords Standards for Roles Standards for Views Standards for the Oracle Security Server Standards for Employees Sample Security Plan Index Sample Security Plan Checklist Chapter 8 Installing and Starting Oracle Segmenting Application Processing Installing Oracle Securely Connecting to the Database Without a Password Installing and Configuring SQL*Net Setting Up Initialization Parameters for Security Chapter 9 Developing a Simple Security Application The Application Overview Preparing the Role-Object Matrix Views Roles Grants Application Control of Access Chapter 10 Developing an Audit Plan Why Audit? Where to Audit How Auditing Works Auditing and Performance Default Auditing Types of Auditing Purging Audit Information Chapter 11 Developing a Sample Audit Application About the Audit Trail Application About Performance and Storage Using the Audit Data in Reports SQL Scripts to Generate Scripts Chapter 12 Backing Up and Recovering the Database What Are the Backup Options? What’s New for Oracle8? What Are the Recovery Options? Chapter 13 Using the Oracle Enterprise Manager What Is the OEM? The DBA Toolkit and Security OEM and the Job Scheduler OEM and the Event Management System Chapter 14 Maintaining User Accounts Application Design Requirements Running the Application Documenting the User State A Sample Script Enhanced Oracle Security Chapter 15 Using the Oracle Security Server About Cryptography Ways to Authenticate Users What’s in the OSS? Configuring and Using the OSS Chapter 16 Using the Internet and the Web Web Basics Evaluating Web Assets and Risks Protecting a Web Site Getting Users Involved Chapter 17 Using Extra-Cost Options Trusted Oracle Advanced Networking Option Oracle Application Server Appendix References Oracle Books Security Books Oracle Electronic References Security Electronic References （英文版）

Oracle至PostgreSQL数据库迁移方案.pptx

Oracle 数据字典很多,通常我记不住所有的名字,我们可以用以下SQL去查数据字典的名字

ORACLE 卸载不像SQL Server 那么简单，本资料教你如何卸载ORACLE ----重点推荐资料

1,108

社区成员

66,453

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章