Click here to Skip to main content
15,039,214 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello all.

I'm using SQL Server 2014.
How can I grant permission to alter the "info" table which is in the schema named "newSch"?
which command should I use?

Regards

What I have tried:

grant alter on table::info to user
(Incorrect syntax near 'table')
Posted
Updated 7-Sep-16 7:39am

1 solution

Try the following
SQL
GRANT ALTER ON newSch.info TO username;

For more information about GRANT, visit GRANT Database Permissions (Transact-SQL)[^]
   
Comments
Maciej Los 7-Sep-16 13:48pm
   
Short And To The Point!
5!
Wendelius 7-Sep-16 23:06pm
   
Thanks :)
Pouria Polouk 7-Sep-16 13:48pm
   
thank you so much.
there is no enough example.
Wendelius 7-Sep-16 23:06pm
   
Glad it was helpful :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900