Grant all on schema.Tablename Privilege!

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:

M/M@DB

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.

Thanks&Regards,

Amit.

Were you the owner of the table, or did you had grant privileges on the table, when you did the grant? You have to be either of the two in the first case. Second, did you notice any errors in the alert log file for that instance?

Sam