I am starting the administration and trying to improve the security of our Oracle database.
Currently, a non-privileged user can see a list of all other users in SQL Developer by expanding the Other Users icon in the database navigation tree.
How to restrict rights, so users will only see those (other) users who have granted them privileges for any object (and not all users, whether privileges are granted or not).
Thank.
, ( , ). , SQL Developer, ALL_USERS, , , . A, , B , A B?
ALL_USERS
, , ALL_USERS ( ), ALL_USERS, . SYS.ALL_USERS, ALL_USERS, . . , , - script , "", - , ..
SYS.ALL_USERS
, SQL Developer ( , ) all_users. ( sysdba):
all_users
revoke select on ALL_USERS from PUBLIC;
, .
EDIT:
@Justin Cave. , :
A, , B , A B?
: A, , B , A B?
, , A () B, () : option a: A , B - b: A , B , B , A B, B , .
"AUTHENTICATEDUSER" "CONNECT" , " " SQL Developer.