DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2001
    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.



  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    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?


    Life is a journey, not a destination!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.