Re: ascential datastage

From: Tim Gorman <tim_at_sagelogix.com>
Date: Tue, 25 May 2004 08:27:53 -0600
Message-ID: <BCD8B409.1576D%tim@sagelogix.com>

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_at_hotmail.com 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_at_hotmail.com
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> 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_at_freelists.org 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
-----------------------------------------------------------------

Received on Tue May 25 2004 - 11:25:16 CDT