User right-clicks on a table name in Object Explorer and selects View Table. Under Script tab, he enables â€Permissionss†checkbox and Toad generates the following command:
GRANT DELETE ON [db].[table] TO domain\username;
GO
Where domain is the domain name of MS Active Directory network logon. Running the above command will result in the following error:
"Error:4/19/2010 4:30:16 PM 0:00:00.000: SQL Server Database Error: Incorrect syntax near..."
Missing brackets around "domain/username".
WORKAROUND:
Enclose domain/username with brackets as such before running command:
GRANT DELETE ON [db].[table] TO [domain\username];
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy