Database access on Microsoft SQL Server

[Jigar Zanzarukiya]

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

Continue reading...