Remove all schema access rights to another schema
SELECT * FROM CBKLPROD.smtb_current_users;
produces results.I have tried to revoke CKEUAT2 from accessing smtb_current_users in CBKLPROD by running the following revoke statement as SYS user
revoke all on CBKLPROD.smtb_current_users from CKEUAT2;
The output states that revoke all succeeded but still the
SELECT * FROM CBKLPROD.smtb_current_users;
Works while in CKEUAT2.
How do I resolve this?Eventually I would like to revoke CKEUAT2 from accessing any object in CBKLPROD.Please give an SQL statement that can do this.