Which command is used for locking a user from performing DML Operation?

ashdba

 Profile Answers by ashdba Questions by ashdba

• Sep 5th, 2010

Revoke insert,update,delete privileges from the user

karthikasathya

 Profile Answers by karthikasathya Questions by karthikasathya

• Oct 1st, 2009

LOCK TABLE  tablename IN EXCLUSIVE MODE;EX:LOCK TABLE emp IN EXCLUSIVE MODE;

Answer Question  Select Best Answer

Why is sys_context used for providing privileges in Oracle?

reyazan

 Profile Answers by reyazan Questions by reyazan

• Oct 16th, 2009

The sys_context function can be used to retrieve information about the Oracle environment.The syntax for the sys_context function is:sys_context( namespace, parameter, [ length ] )namespace is an Orac...

Answer Question  Select Best Answer