Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

how to know details about all saviynt tables which are not visible in data Analyzer

sampath18
Regular Contributor II
Regular Contributor II

Hi Team,

can you please guide us in finding details of saviynt db tables which are not visible from data analyser. we were running below query in v21.0 to get the coloumn names of hidden tables. But this query is no longer working v23.4. So were there any changes in latest version of saviynt and alternate way to get these tables?

Query : SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'usershistory';

Message on Saviynt screen : Operation not allowed as you are entering a value that resembles or contains SQL query

Who Me Too'd this topic