Spaghetti Tom: If you look at Users under Security at a database in SSMS and there is a little red X by the user that means that the user does not have "connect abilities" for the database.

Friday, May 31, 2019

If you look at Users under Security at a database in SSMS and there is a little red X by the user that means that the user does not have "connect abilities" for the database.

The SQL command to give someone back their access is:

grant connect to [jimAcosta]

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)