Tuesday, December 14, 2021

Get all databases a login can access

-- First Check you have access in all the databases in your system..

SELECT s.* FROM master.sys.databases s WHERE HAS_DBACCESS(s.name) = 1

-- List all the databases a login can access in the system.

EXECUTE AS LOGIN = 'Sl_Mwbe_write'  

SELECT s.name FROM master.sys.databases s

WHERE HAS_DBACCESS(s.name) = 1

REVERT

No comments:

Post a Comment