What are the challenges you face when working across database platforms? Take the survey
Options

4.0.3 only lists some users for GRANT

MikeyCMikeyC Posts: 249 Bronze 3
edited November 23, 2009 5:50AM in SQL Prompt Previous Versions
The release notes for 4.0.3 say: "GRANT Statement should have list of USERS" I guess the keyword there is should.

Given:
GRANT SELECT ON dbo.<table> TO <cursor>

It brings up suggestions, and it includes some of the users of the DB, but not all of them. (It appears to only show SQL users not Windows users or Groups.)

It is a step in the right direction...

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Apologies for the inconvenience caused by this.

    I have logged this issue in our internal tracking system (SP-2875) so that our development team can have a look at it.

    Kindly let me know if you have any other issues or questions regarding this issue.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.