0
GRANT ALL PRIVILEGES ON . 
TO 'abc'@'xxx.xxx.xxx.xxx' IDENTIFIED BY '*' WITH GRANT OPTION;

This query is in Mysql and I want the SQL Server version of this query. I tried all ways including online converter (the online converter simply copy paste the code not converting) but no results. If anybody know please let me know, thanks.

a_horse_with_no_name
  • 497,550
  • 91
  • 775
  • 843
Praneeth Gopinathan
  • 167
  • 2
  • 6

1 Answers1

0

from microsoft docs

GRANT ALL ON dbo.YourTable TO abc WITH GRANT OPTION
Krushnakant
  • 59
  • 2
  • 2
  • 9