If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Threaded View

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.