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
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]
March 5, 2021 at 8:22 pm
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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy