Re: [Schemaspy-users] How can I set an Oracle Role?

[John C. <cur...@ya...>]

JDBC doesn't know anything about roles and therefore doesn't provide any APIs to 
query or set them.  To provide that support SchemaSpy would require a mechanism 
to specify arbitrary SQL to be executed after the connection is established.  It 
should be possible to implement something like that, but it would require a bit 
of thought and work.

 John



________________________________
From: "Bohannon, Jerry (SAIC)" <Jer...@bp...>
To: sch...@li...
Sent: Thu, May 19, 2011 5:54:12 PM
Subject: [Schemaspy-users] How can I set an Oracle Role?

  
I am merely a user in an Oracle database. I am not the schema owner and do not 
have the schema password. By default my userid does not have read access to the 
schema I want to analyze with SchemaSpy. However, I do have a non-default role 
gives me read access to the schema.
 
In SQL, I do the following:
sqlplus <userid>/<pwd>@<instance>
>set role ILX_DQSA_ADMIN;
 
After the set role is executed, I can see the tables in the schema.
 
When I run SchemaSpy, I get this message:
     No tables or views were found in schema 'ILX37_GLOBAL'.
      The schema exists in the database, but the user you specified (<userid>)
         might not have rights to read its contents.
 
Is there a way to tell SchemaSpy to set the required role after it connects but 
before it tries to gather the schema details?