Select access to sys.dba_extents
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 122
- Joined: Mon Jul 05, 2004 1:33 pm
- Location: MA
Select access to sys.dba_extents
Hi all,
Why does the user ID under which DataStage connects to Oracle require select permissions to sys.dba_extents?
Thanks.
Why does the user ID under which DataStage connects to Oracle require select permissions to sys.dba_extents?
Thanks.
Regards
Sonia Jacob
Sonia Jacob
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 122
- Joined: Mon Jul 05, 2004 1:33 pm
- Location: MA
-
- Participant
- Posts: 122
- Joined: Mon Jul 05, 2004 1:33 pm
- Location: MA
[quote="richdhan"]Hi,
We had a similar issue.
Follow this [url=viewtopic.php?t=87409]link[/url]. It should be resolved soon.
HTH
--Rich[/quote]
Thanks m8, your post helped me out
BR
/Mats
We had a similar issue.
Follow this [url=viewtopic.php?t=87409]link[/url]. It should be resolved soon.
HTH
--Rich[/quote]
Thanks m8, your post helped me out
BR
/Mats
/Mats, 3
Creating role for the privileges.
Hi,
You can also create a role and Grant that role to the user ids using Datastage jobs.
CREATE ROLE DSXE;
GRANT SELECT on sys.dba_extents to DSXE;
GRANT SELECT on sys.dba_data_files to DSXE;
GRANT SELECT on sys.dba_tab_partitions to DSXE;
GRANT SELECT on sys.dba_objects to DSXE;
GRANT SELECT on sys.all_part_indexes to DSXE;
GRANT SELECT on sys.all_part_tables to DSXE;
GRANT SELECT on sys.all_indexes to DSXE;
Once the role is created, grant it to users who will run DataStage jobs, as
follows:
GRANT DSXE to <oracle user id>;
Cheers,
Sajeed.
You can also create a role and Grant that role to the user ids using Datastage jobs.
CREATE ROLE DSXE;
GRANT SELECT on sys.dba_extents to DSXE;
GRANT SELECT on sys.dba_data_files to DSXE;
GRANT SELECT on sys.dba_tab_partitions to DSXE;
GRANT SELECT on sys.dba_objects to DSXE;
GRANT SELECT on sys.all_part_indexes to DSXE;
GRANT SELECT on sys.all_part_tables to DSXE;
GRANT SELECT on sys.all_indexes to DSXE;
Once the role is created, grant it to users who will run DataStage jobs, as
follows:
GRANT DSXE to <oracle user id>;
Cheers,
Sajeed.
Especially if the table names have sys in itnarasimha wrote:The DBA's are never happy to give these rights to anyone
Jokes apart, if they understand why the tool requires such access, they will give you access. They just want to be sure on their part that such an access will not in any way harm any thing. Some companies have not used such tools which require such vast access and hence there In House standards are such that they cannot give access. I had sucha client where they had just bought the tool and were refusing to give me anything over select and execute permission on regular tables. That was some long gory hours that i spent with the dba group and in house security folks.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Very true, They made me take the director's approval for read only access to a few sys tables while I was working with Oracle - OMW.DSguru2B wrote:Especially if the table names have sys in itnarasimha wrote:The DBA's are never happy to give these rights to anyone
Jokes apart, if they understand why the tool requires such access, they will give you access. They just want to be sure on their part that such an access will not in any way harm any thing.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.