diff options
Diffstat (limited to 'tests/dialects/test_tsql.py')
| -rw-r--r-- | tests/dialects/test_tsql.py | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/tests/dialects/test_tsql.py b/tests/dialects/test_tsql.py index 7114750..453cd5a 100644 --- a/tests/dialects/test_tsql.py +++ b/tests/dialects/test_tsql.py @@ -1998,3 +1998,10 @@ FROM OPENJSON(@json) WITH ( "tsql": "SELECT COUNT(1) FROM x", }, ) + + def test_grant(self): + self.validate_identity("GRANT EXECUTE ON TestProc TO User2") + self.validate_identity("GRANT EXECUTE ON TestProc TO TesterRole WITH GRANT OPTION") + self.validate_identity( + "GRANT EXECUTE ON TestProc TO User2 AS TesterRole", check_command_warning=True + ) |