Grant all on schema.Tablename Privilege!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Grant all on schema.Tablename Privilege!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    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.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
    Thanx
    Sam



    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