Database Administration (MOSC)

MOSC Banner

Does granting or revoking object privilege make the target table lock exclusively ?

edited Nov 23, 2011 6:11PM in Database Administration (MOSC) 3 commentsAnswered
 There are two accounts on target database.

 USER A has schema objects (tables and indexes).
 USER B has privilege to select all of A's table, but way of granting was duplicated.

 B granted object privilege via role and directly with admin option.
 So, I decided to revoke direct privilege.
 
 SQL>  REVOKE SELECT ON A.TABLE_NAME FROM B ;
 
 These SQLs completed with no errors.
 
 But We found some data loading processes behaved unexpectedly.
 It suspended for a few seconds at the same time as revoking privilege from B .
 It accessed using not B but A.

 If it had been arise from my SQL, I suspect them locked tables or dictionaries.

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