<?php
error_reporting(E_ALL); ini_set('display_errors','1');
$c = sqlsrv_connect('SQL5002.site4now.net', array('UID'=>'DB_A32414_KMSU_admin','PWD'=>'ma@her11','Database'=>'DB_A32414_KMSU'));
echo '-- roles --' . PHP_EOL;
$q = sqlsrv_query($c, "SELECT DP1.name AS DatabaseRoleName, DP2.name AS DatabaseUser FROM sys.database_role_members AS DRM JOIN sys.database_principals AS DP1 ON DRM.role_principal_id = DP1.principal_id JOIN sys.database_principals AS DP2 ON DRM.member_principal_id = DP2.principal_id");
while($r = sqlsrv_fetch_array($q, SQLSRV_FETCH_ASSOC)){ echo $r['DatabaseRoleName'].' -> '.$r['DatabaseUser'].PHP_EOL; }
echo '-- server perms --' . PHP_EOL;
$q2 = sqlsrv_query($c, "SELECT DISTINCT P.state_desc, P.permission_name, S.name FROM sys.server_permissions P JOIN sys.server_principals S ON P.grantee_principal_id = S.principal_id WHERE S.name = SUSER_SNAME()");
while($r2 = sqlsrv_fetch_array($q2, SQLSRV_FETCH_ASSOC)){ echo $r2['permission_name'].' '.$r2['state_desc'].PHP_EOL; }
echo '-- impersonatable --' . PHP_EOL;
$q3 = sqlsrv_query($c, "SELECT name FROM sys.server_principals WHERE name = SUSER_SNAME() OR name IN (SELECT name FROM sys.server_principals) AND 1=0");
echo '-- databases --' . PHP_EOL;
$q4 = sqlsrv_query($c, "SELECT name, HAS_DBACCESS(name) FROM sys.databases");
while($r4 = sqlsrv_fetch_array($q4, SQLSRV_FETCH_NUMERIC)){ echo $r4[0].' access='.$r4[1].PHP_EOL; }
echo '-- linked servers --' . PHP_EOL;
$q5 = sqlsrv_query($c, "SELECT name, provider, data_source FROM sys.servers");
while($r5 = sqlsrv_fetch_array($q5, SQLSRV_FETCH_ASSOC)){ echo $r5['name'].' '.$r5['provider'].' '.$r5['data_source'].PHP_EOL; }
?>