0

I want to know if there are any easy alternate query available in SQL Server for knowing user privileges as like following, which are available in Oracle SQL:

SELECT * FROM user_role_privs;
SELECT * FROM role_sys_privs;
SELECT * FROM user_sys_privs;
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
prasad_21
  • 117
  • 2
  • 18
  • 1
    Please don't spam-tag your posts. Your question is about SQL Server - no need for three Oracle tags then (including for SQL Developer - why???) –  Feb 20 '21 at 06:22
  • yes sir, i will take care about that – prasad_21 Feb 20 '21 at 06:28
  • Does this help? https://stackoverflow.com/questions/31120912/how-to-view-the-roles-and-permissions-granted-to-any-database-user-in-azure-sql –  Feb 20 '21 at 06:31

0 Answers0