Re: How to create a DDL for a schema

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 10 Nov 2005 05:51:05 -0800
Message-ID: <1131630665.576332.170000@o13g2000cwo.googlegroups.com>

The issue is related to privileges.
User A does not have the proper access to the objects in user B schema. System happens to work because he has the "DBA" role which comes with enough privileges to do almost anything to any other schema. You can grant system level privileges to user A (such as "select any table"), or grant him specific object privilege (such as select on B.table1), or grant him a dba type role.
hth Received on Thu Nov 10 2005 - 07:51:05 CST