如何查询数据库监控用户当前拥有的权限

Oracle数据库

select * from user_tab_privs where GRANTEE = ‘ONEKEEPER’;

SQL Server数据库

EXECUTE AS LOGIN = ‘onekeeper’;
SELECT FROM fn_my_permissions(NULL, ‘SERVER’);
SELECT FROM fn_my_permissions (NULL, ‘DATABASE’);
SELECT * FROM fn_my_permissions(‘master.dbo.xp_readerrorlog’, ‘OBJECT’)
REVERT;