SQL Syntax Error Creating Roles

Question

Keep getting an error when trying to grant a specific role to user:

Grant role role_1 to maintenance;

Error:

Incorrect syntax near 'role_1'

Want to edit it so the Grant role to user works

[Here](http://stackoverflow.com/questions/11008399/t-sql-how-to-grant-role-to-user) is your answer for SQL Server — cha, Oct 13 '15 at 23:29
I can't see what the Grant Role role_1 fix was on SQL Server. — LebronJames, Oct 13 '15 at 23:34

Aung Myo Linn · Answer 1 · 2015-10-13T23:48:38.693

0

GRANT {role_name} TO {user_name};

for T-SQL, Here's the simplified syntax for GRANT

GRANT { ALL [ PRIVILEGES ] }
      | permission [ ( column [ ,...n ] ) ] [ ,...n ]
      [ ON [ class :: ] securable ] TO principal [ ,...n ] 
      [ WITH GRANT OPTION ] [ AS principal ]

in your case, simply

GRANT role_1 TO maintenance;

edited Oct 13 '15 at 23:48

answered Oct 13 '15 at 23:39

Aung Myo Linn

2,820
3
27
38

Thanks but still getting Syntax Error for some reason – LebronJames Oct 14 '15 at 02:02

SQL Syntax Error Creating Roles

1 Answers1