是否可以从查询中获取访问SQL Server或Oracle中的表的应用程序列表？

SELECT DISTINCT program_name
FROM sys.dm_exec_sessions
WHERE database_id = DB_ID('YourDatabaseName')
AND program_name <> 'Microsoft SQL Server Management Studio'

SELECT DISTINCT program
FROM v$session
WHERE sid IN (
  SELECT DISTINCT sid
  FROM v$mystat
  WHERE rownum = 1
  CONNECT BY LEVEL <= 100
)
AND type = 'USER'
AND username = 'YourUsername'
AND osuser IS NOT NULL;