Share via

Database access on Microsoft SQL Server

Anonymous
2024-07-26T11:33:52+00:00

We are using HAS_DBACCESS function to check if user given by client has access to the database which is there in sys.databases. Customer is claiming that they have given access to all the databases on that server but the function HAS_DBACCESS returning zero for all those databases. Can someone help me with which all the permission does this function check to return 1 in response for particular database? Am I missing something with HAS_DBACCESS function?

Which all permission customer need to give to user so that HAS_DBACCESS return 1 for the logged in user for the database in sys.databases table?

Windows for business | Windows Server | Windows cloud | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-07-26T12:13:35+00:00

    Hello Jigar Zanzarukiya,

    Thank you for posting in Microsoft Community forum.

    From the description above, I understand your question is related to access database on SQL server.

    Since there are no engineers dedicated to SQL in this forum. in order to be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.

    Here is the link for Q&A forum.
    Questions - Microsoft Q&A

    Click the "Ask a Question" button in the upper right corner to post your question and type "SQL" tag and select any tags related to your productions.

    I hope the information above is helpful.

    If you have any question or concern, please feel free to let us know.

    Best Regards,
    Daisy Zhou

    0 comments