Forum Discussion

BetterToday's avatar
BetterToday
Brass Contributor
Sep 29, 2021
Solved

Database Permission CONNECT listed twice in SSMS

For a test I created a user [u1] and granted him the CONNECT database permission:     GRANT CONNECT TO [u1]     Then, verifying my command, I noticed that the CONNECT permission is listed twi...
  • olafhelper's avatar
    Sep 29, 2021

    BetterToday , that's "simply" a bug in SSMS, exists in older version and also in English version.

    Tick on both checkbox and let SSMS generate the script for it, you will see, it's the same GRANT CONNECT sql command.

     

     

    Olaf

Resources