Re: ascential datastage

So, give it to them.  Create a private view within their account named
"DBA_EXTENTS" that points to USER_EXTENTS:

    create or replace view dba_extents
    as
    select  user    owner,
            segment_name,
            partition_name,
            segment_type,
            tablespace_name,
            extent_id,
            0       file_id,
            0       block_id,
            bytes,
            blocks,
            0       relative_fno
    from    user_extents;

Better to bend before breaking...


on 5/20/04 12:06 PM, Michael McMullen at ganstadba@xxxxxxxxxxx wrote:

> Anybody using Ascentail datastage tool. A select only user on one schema is
> wanting to use it and says they need select privileges on dba_extents in
> order to use the tool for extraction. Boggles my mind why but I'm convinced
> they have it wrong.
> 
> Thanks
> Mike
> ganstadba@xxxxxxxxxxx
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: