GRANT CREATE SEQUENCE syntax error

• webrunner

  SSC-Dedicated

  Points: 31991

  More actions

  March 5, 2021 at 5:59 pm

  Go to Answer

  #3853930

  Hello experts,

  I am getting this error

  Msg 102, Level 15, State 1, Line 6192
  Incorrect syntax near 'CREATE SEQUENCE'.

  when I try this command:

  GRANT CREATE SEQUENCE ON [sys].[sysrowsets] TO [MySQLLogin]

  Does anyone know what the correct syntax is? Seems puzzling because I don't know how else to issue this command.

  Thanks for any help.

  -- webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• ratbak

  Default port

  Points: 1414

  More actions

  March 5, 2021 at 7:27 pm

  Answer

  #3853979

  Permissions are granted on schema, not individual tables: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-2016

   

  Requires CREATE SEQUENCE, ALTER, or CONTROL permission on the SCHEMA.

  GRANT CREATE SEQUENCE ON SCHEMA::Test TO [AdventureWorks\Larry]

• webrunner

  SSC-Dedicated

  Points: 31991

  More actions

  March 5, 2021 at 8:22 pm

  #3854005

  Thanks!! I have marked your response as the answer.

  -- webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html