tag:blogger.com,1999:blog-7998687752365941655.post8756185430385262525..comments2022-03-25T16:46:26.176+05:30Comments on VM Blogs: Checking database access rights for a user in a sqlserver instanceVisakh Murukesanhttp://www.blogger.com/profile/02874515877085669105noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7998687752365941655.post-791820737735910932013-05-06T08:08:06.324+05:302013-05-06T08:08:06.324+05:30The given code will check for the access right in ...The given code will check for the access right in various databases in a server for the current logged in user. As you see HAS_DBACCESS() doesnt have a passed argument so it will always use current logged in user as the context.Visakh Murukesanhttps://www.blogger.com/profile/02874515877085669105noreply@blogger.comtag:blogger.com,1999:blog-7998687752365941655.post-2382158397684283852013-05-05T21:08:34.369+05:302013-05-05T21:08:34.369+05:30Thanks Visakh.
IT will tell about only Databases b...Thanks Visakh.<br />IT will tell about only Databases but how you tell which user for which database?Anonymoushttps://www.blogger.com/profile/10091665811389468485noreply@blogger.com