Give rights to a table

• lallen-661487

  Mr or Mrs. 500

  Points: 531

  More actions

  June 23, 2009 at 8:37 am

  #384828

  I want to give drop table rights to one specific table. What is the syntax? I haven't found any on the web.

  example:

  Grant drop table on table1 to Roger

• mayank jarsaniya

  Hall of Fame

  Points: 3532

  More actions

  June 23, 2009 at 8:51 am

  #1014004

  --First create a user in Database.

  GRANT ALTER ON TABLE_NAME TO USER