Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Cannot access Users table in Data Analyzer

yuki
New Contributor II
New Contributor II

When I try to access the Users table in Data Analyzer, I get an “Error : SELECT command denied to user~~for table ‘users’” and cannot access it.

Please troubleshoot this problem.

1 REPLY 1

Amit_Malik
Valued Contributor II
Valued Contributor II

Dont use select * from users ,,, 

Create quesry with attributes that you need to view for example, select username , startdate, statuskey , firstname from users limit 100 

Some of the columns in users table are not allowed to view. That is why * doesnt work

 

Kind Regards,
Amit Malik
If this helped you move forward, please click on the "Kudos" button.
If this answers your query, please select "Accept As Solution".