SQL> conn guest/guest
SQL> select * from victor.v_usersinfo;
                      *
ERROR at line  1 :
ORA- 01031 : insufficient privileges

conn victor/victor

create or replace view victor.v_UsersInfo as 
    select u.id, u.name, 
             decode( count(AU.Users_ID),  0 ,  0 ,  1  )  "IsActive" 
    from victor.Users U, user2.ActiveUsers AU 
    where U.ID = AU.USERS_ID (+)
    group by u.id, au.users_id, u.name

CREATE ROLE  "GUEST_ROLE"   NOT IDENTIFIED

GRANT SELECT ON   "VICTOR" . "V_USERSINFO"  TO  "GUEST_ROLE" 

GRANT  "GUEST_ROLE"  TO GUEST

SQL> conn victor/victor
SQL> select * from victor.v_usersinfo;

        ID NAME                   IsActive
 ---------- -------------------- ----------
 
          1  GUEST                          0 
          2  PP                           0 
          3  VICTOR                         0 
 3  rows selected.