user map is auto unchecking sql?

Seshagiri Rao Vadrevu 101 Reputation points
2021-07-15T04:13:50.28+00:00

hi all,

iv tried to give access to a specific db for a user, via gui ( instance -> security -> logins -> user -> right click properties -> user mapping )

where I'm checking map -> and gave access as a DB writer and clicked ok

the task executed successfully but when I check the user there is DB writer permission but the map is getting un-checked automatically

can anyone help me fix this

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,644 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,436 Reputation points
    2021-07-15T06:36:34.58+00:00

    Hi @Seshagiri Rao Vadrevu ,

    the task executed successfully but when I check the user there is DB writer permission but the map is getting un-checked automatically

    Did you restart SSMS and try again? What‘s your version?
    Does your user actually have permission to write?

    Best regards,
    Seeya


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.