Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

revoke select on "all_source" view from the public ?

712307Sep 23 2009 — edited Sep 25 2009

Fellow DBA's

There is a security audit going on at my client's site and one of the requirements is to
revoke select on "*all_source*" view from the public .

1) Can Someone point out if there are any immediate ramifications of doing this (As in will the application
get affected in any way.. I don't assume so ) I scoured metalink but couldn't find any docs which cautions agaist it .

2) Now there are over 150 databases (8i,9i,10g) with several different development teams . How do i go about ensuring that the developers are not affected by this change . DO I need to create a seperate view based on this one for seperate teams .. ?

I am kinda new to this and any pointers are much appreciated

Regards,
SV

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2009

Added on Sep 23 2009

#general-database-discussions

12 comments

3,467 views