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!

Restricting acces to all_users

440352Mar 16 2005 — edited Mar 16 2005

Hi

I created a new user and assigned him a tablespace the same as his username.

This user uses an application that shows all the users that exist in the database, for that it sends the query "select * from all_users".

I don't want him to be listing all the users in the database, how can I restrict him for executing that query and from listing all the users in the system?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 13 2005

Added on Mar 16 2005

#general-database-discussions

4 comments

802 views