Re: ascential datastage

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Tue, 25 May 2004 12:34:18 -0400
Message-ID: <BAY9-DAV12eLR1x19TT0004bc5a@hotmail.com>

Thought of that but here's what they want select access on and it has to be prefixed by sys. Also, the user doesn't own the data just select privileges.
>DBA_EXTENTS
>DBA_DATA_FILES
>DBA_TAB_PARTITONS
>DBA_OBJECTS
I'm thinking about fine grained access control but just wondering if it can be used against dba_views and how I can break it apart ie. where owner = myuser on some views and where tablespace = mytablespace on others.

Mike
ganstadba_at_hotmail.com
----- Original Message -----
From: "Tim Gorman" <tim_at_sagelogix.com>
To: <oracle-l_at_freelists.org>
Sent: Tuesday, May 25, 2004 10:27 AM
Subject: 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_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
> -----------------------------------------------------------------
>

---

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:34:55 CDT