Hello,
if I want to GRANT some rights on a table (like GRANT SELECT ON), the intellisense seems to work OK. But if I start typing GRANT EXECUTE ON, intellisense is providing me with a list of tables instead of stored procs!
In the same vein, when I type to TO part of the GRANT statement, I'd like to have automagically a list of principals (i.e. users/roles).
As a nice-to have, when typing GRANT SELECT, I would not expect a list after typing SELECT (yes, I know, this is really a nice-to-have!)
I haven't tried the REVOKE statement though ...
With kind regards,
Emmanuel
if I want to GRANT some rights on a table (like GRANT SELECT ON), the intellisense seems to work OK. But if I start typing GRANT EXECUTE ON, intellisense is providing me with a list of tables instead of stored procs!
In the same vein, when I type to TO part of the GRANT statement, I'd like to have automagically a list of principals (i.e. users/roles).
As a nice-to have, when typing GRANT SELECT, I would not expect a list after typing SELECT (yes, I know, this is really a nice-to-have!)
I haven't tried the REVOKE statement though ...
With kind regards,
Emmanuel