Database Administration (MOSC)

MOSC Banner

How revoke privileges from user ?

edited Feb 28, 2012 10:32PM in Database Administration (MOSC) 4 commentsAnswered
 Hi all,
   I created a TEST user and have been used it to kill session and alter user. And I grant some privileges to it success ! My db server has another schema with name is PRODUCT. And when I try use TEST user to select and insert some tables that belong to PRODUCT --> TEST can do this ? But I did not grant INSERT and SELECT privileges to TEST !

   After created TEST user, I grant some privileges to TEST such as:

---------------------------------------
grant connect, oem_monitor to TEST;

GRANT EXECUTE ON SYS.kill_session to  TEST ;
GRANT SELECT ON V_$SESSION  TO  TEST ;

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