Database Administration (MOSC)

MOSC Banner

Remove all schema access rights to another schema

edited Jul 10, 2011 3:47AM in Database Administration (MOSC) 4 commentsAnswered
Hallo!I have 2 database schemas CKEUAT2 and CBKLPROD.CKEUAT2 can access tables of CBKLPROD since the select statement executed in CKEUAT2

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center