Skip to Main Content

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!

dba_ & ALL_ Table access

Gowthaman Ganesan-OracleNov 10 2014 — edited Nov 10 2014

Hi,

1. i have created user

2. then login into newly created user

3. i try to access dba_ , all_ tables , i get the error " table or view doesn't exits".

dba_data_files

dba_tablespaces

.....

my question is, i would like to access all DBA_ and ALL_ tables in newly created schema.... instead of give grant select on <object name > to <new user>, any other system privileges for access the DBA_  tables.

thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 8 2014
Added on Nov 10 2014
3 comments
841 views