Hi all!

To-day I faced a peculiar situation:

1.I had granted to all the users the following privileges:

Grant all on Balaji.Tablename to x;

By granting all to the users as above,what are the privileges acquired by the users.

2.After the above statements were executed,one particular user loggged on by his name as:


After this,when he tried to delete records from a particular table,the cursor immediately went into a hanged state causing me shutdown the client machine and restart sql*plus from where the above delete statement was executed.

Could you guess what could have gone wrong here.

After this,I had to restart the server predicting it would solve the problem.