Skip to main content
Question

how to check PSO user dataset define

  • June 5, 2024
  • 1 reply
  • 21 views

Forum|alt.badge.img+7

let me know how to check PSO user ViewAllDatasets define in Database ? its means table name 

 

1 reply

roklde
Superhero (Employee)
Forum|alt.badge.img+27
  • Superhero (Employee)
  • 794 replies
  • June 5, 2024

Hi @ERCEUPENSI !

I guess you want to list all users with the permission ViewAllDatasets allowed? Try the following query against the PSO System Database:
 

select user_id from USER_PERMISSION WHERE permission_id = 'ViewAllDatasets' AND ALLOW = 1


Best regards
Roman