-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Can't see Oracles SYS.DBA_ROLE_PRIVS table
PostPosted: Tue Apr 25, 2006 1:40 pm 
Beginner
Beginner

Joined: Wed Nov 02, 2005 3:29 pm
Posts: 20
Hibernate tool version:
3.1.0.beta5

Mapping documents:
<hibernate-reverse-engineering>
<table-filter match-schema="SYS" match-name="DBA_ROLE_PRIVS"/>
<table-filter match-schema="NTWKCOMP" match-name="NC_CONTACT"/>
<table-filter match-schema="NTWKCOMP" match-name="NC_ORG_UNIT"/>
<table-filter match-schema="NTWKCOMP" match-name="NC_ORG_UNIT_TYPE_TBL"/>
<table-filter match-schema="NTWKCOMP" match-name="NC_ORG_UNIT_CONTACT_TYPE_TBL"/>
<table-filter match-schema="NTWKCOMP" match-name="NC_VENDOR_CONTACT_TYPE_TBL"/>
</hibernate-reverse-engineering>

Name and version of the database you are using:
Oracle9



Any idea why SYS.DBA_ROLE_PRIVS is hidden/unavailable to tools?

Code:
2006-04-25 10:31:51,269 607155 [       Worker-4] DEBUG ng.dialect.JDBCMetaDataDialect  - getTables(null.null.null)
2006-04-25 10:31:51,272 607158 [       Worker-4] DEBUG riverManagerConnectionProvider  - total checked-out connections: 0
2006-04-25 10:31:51,273 607159 [       Worker-4] DEBUG riverManagerConnectionProvider  - using pooled JDBC connection, pool size: 0
...
2006-04-25 10:31:53,579 609465 [       Worker-4] DEBUG ibernate.cfg.reveng.JDBCReader  - Table org.hibernate.cfg.reveng.TableIdentifier(SYS.DBA_PROCEDURES) excluded by strategy
2006-04-25 10:31:53,579 609465 [       Worker-4] DEBUG ibernate.cfg.reveng.JDBCReader  - Table org.hibernate.cfg.reveng.TableIdentifier(SYS.DBA_PUBLISHED_COLUMNS) excluded by strategy
2006-04-25 10:31:53,580 609466 [       Worker-4] DEBUG ibernate.cfg.reveng.JDBCReader  - Table org.hibernate.cfg.reveng.TableIdentifier(SYS.DEFERRCOUNT) excluded by strategy


I know I can get to the table since:
Code:
  select * from sys.dba_role_privs

works just fine with DbVisualizer

George


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.