Hi @Chaitanya Kiran ,
Please check below T-SQL.
--List all effective permissions for securable class server EXECUTE AS LOGIN = 'Cathy' Go SELECT * FROM fn_my_permissions(NULL, 'SERVER'); Go --List all effective permissions for user Cathy in database AdventureWorks2019 EXECUTE AS USER = 'Cathy' GO USE AdventureWorks2019 GO SELECT * FROM fn_my_permissions(null, 'database'); GO
Refer to the blog List SQL Server Login and User Permissions to get more detail.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.