Strange problem : One of my friend came across a strange problem. He had a set of Users (not Logins) in the newly created database that, in SSMS, have the red down arrow in their icon. They act as if they are disabled.
I knew that starting from SQL server 2005 , one way to disable a user in a database is to run a REVOKE CONNECT FROM permission for that user . If that is the case , you can run a GRANT CONNECT TO and fix this problem hence I did same thing and issue was resolved.
Point to jotting down this here cause I had discussion on this with many DBA friends and most of them said that we need to delete the user and re-create it.
Even recreating a user can be a solution but I wish to highlight that it is not the only solution.
We can run below code and resolve the issue:-
USE <YourDatabase>
Go
GRANT CONNECT TO User1
Hope it will help.
I knew that starting from SQL server 2005 , one way to disable a user in a database is to run a REVOKE CONNECT FROM permission for that user . If that is the case , you can run a GRANT CONNECT TO and fix this problem hence I did same thing and issue was resolved.
Point to jotting down this here cause I had discussion on this with many DBA friends and most of them said that we need to delete the user and re-create it.
Even recreating a user can be a solution but I wish to highlight that it is not the only solution.
We can run below code and resolve the issue:-
USE <YourDatabase>
Go
GRANT CONNECT TO User1
Hope it will help.
Warm Regards,
Chhavinath Mishra
Sr. Specialist Database Administrator
No comments:
Post a Comment