Click HERE to see how Saviynt Intelligence is transforming the industry. |
06/22/2022 04:06 AM
Hi Folks,
is it possible to have read access on Saviynt DB and can we develop queries on SQL editor instead of using Saviynt analytic.
Regards,
Arvind
06/22/2022 04:12 AM - edited 06/22/2022 04:13 AM
Hi Arvind,
Not sure which version you are on, for v2021 this is not possible. Please reach out to our support team via FD ticket and they will be able to help you more on this.
You can also use Data Analyzer in the meantime.
06/22/2022 04:16 AM
Hi Nikita,
We have currently version Saviynt v5.5SP3, © Copyright 2022, Saviynt All Rights Reserved.
In data Analyzer some of tables are restricted.
Regards,
Arvind
06/22/2022 04:21 AM
Thanks for confirming ...Please raise a FD ticket and our support team will be able to help you.
06/22/2022 08:01 AM
Hi ,
I was also having similar issues and was desperately looking for read only access to use Sql Workbench for constructing queries.
I remember creating the ticket as well and it was closed saying we will not be provided access to DB even if it is read only( We are also SP3.5 version)
Thanks
Shyam
06/22/2022 10:43 AM
You can always run query from Analytics --> Analytics Config List -->
add below details
_-> Click on Preview 🙂
06/22/2022 10:49 AM
Hi,
I'm only using the analytical module right now while creating SQL queries. However, debugging SQL queries on a user interface is not much more illuminating. The precise error results are not displayed to me.
Regards,
Arvind
06/22/2022 11:05 AM
Error log provide detail error if column name is wrong or subquery returns more than 1 value. which error you are looking for ?