please help me to understand the problem here.

CREATE OR REPLACE VIEW MDSYS.USER_SDO_GEOM_METADATA
(
TABLE_NAME,
COLUMN_NAME,
DIMINFO,
SRID
)
AS
SELECT SDO_TABLE_NAME TABLE_NAME,
SDO_COLUMN_NAME COLUMN_NAME,
SDO_DIMINFO DIMINFO,
SDO_SRID SRID
FROM SDO_GEOM_METADATA_TABLE,
(select username from user_users)
WHERE sdo_owner = username
/
GRANT DELETE ON MDSYS.USER_SDO_GEOM_METADATA TO PUBLIC
/
GRANT INSERT ON MDSYS.USER_SDO_GEOM_METADATA TO PUBLIC
/
GRANT SELECT ON MDSYS.USER_SDO_GEOM_METADATA TO PUBLIC
/
GRANT UPDATE ON MDSYS.USER_SDO_GEOM_METADATA TO PUBLIC
/


I have three users with DBA privileges. one of them can access the data in this view but the others two are not.

Can someone explain to me what was the problem here ???
and what I should do to make the other two users access the data on this view.


Thanks