http://qs1969.pair.com?node_id=11144241

cLive ;-) has asked for the wisdom of the Perl Monks concerning the following question:

I've tried to create a DBIx Schema for an Oracle DB, but all I'm getting is the basic schema class. It's been a while since I've touched Oracle (and DBIx::Class from first principles), so I'm wondering if I'm missing something obvious.

perl -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:./lib -e 'make_schema_at("My::Schema", { debug => 1 }, [ ... credentials ... ]

On running, I just get the one module:

./lib/My/Schema.pm

I was under the impression that I would get a full schema dump of all the tables in the DB.

Using the same credentials, I can get a $dbh and run the query

SELECT table_name FROM all_tables ORDER BY table_name

to get a list of all the tables, so why can't I get the Schema definitions for them? Would it be a user permission? If so, how would I check what perms my user has? At the moment, I'm going in blind and not sure what questions I need to be asking, so any insights appreciated. If I need to get a different user for this I guess I'll put in the request, but I was hoping to be able to work it out with what I have.

Running SELECT * FROM USER_TAB_PRIVS I see a bunch of select/update/execute perms.

Running SELECT * FROM USER_SYS_PRIVS gives me nothing.

Running SELECT * FROM USER_ROLE_PRIVS gives me a bunch of perms (not sure what they all are just yet, only that they exist).