Re: ascential datastage
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <tim@xxxxxxxxxxxxx>
- Date: Tue, 25 May 2004 12:34:18 -0400
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@xxxxxxxxxxx
----- Original Message -----
From: "Tim Gorman" <tim@xxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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@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 //www.freelists.org/archives/oracle-l/
> > FAQ is at //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 //www.freelists.org/archives/oracle-l/
> FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
