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.

Praneeth T T
  • 305
  • 3
  • 9

1 Answers1

0

from microsoft docs

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