Privileges for all tables in fdhdata

agesser — Mon, 22 Jan 2024 14:42:08 GMT

hi all,

we create internal entities for VI that are stored in fdhdata

when we are going to SAS Studio, we can't see those tables

we can see them when we connect to PG directly

question: what privilege we should grant for our SAS STUDIO user so we will see and be able to query from these tables?

Thanks a lot,

Alex.

Re: Privileges for all tables in fdhdata

TimKingsbury — Thu, 08 Feb 2024 19:37:38 GMT

Hello, I can recommend two possible approaches:

1. In Visual Investigator, create a Workspace and then export your data using the "Explore and Visualize Data" window. This will export your data to CAS. I believe SAS Studio (and SAS Visual Analytics) can readily access it from there. Refer to "Export Data to SAS Visual Analytics" in the user's guide for more detail.

2. Alternatively, direct access through Postgres is possible, but not recommended. To do this, you would need to contact your DBA and ask to create a Postgres user account with minimal privileges. Ideally read-only access to the specific tables that you are interested in would be sufficient.

I hope this helps!

Tim

topic Re: Privileges for all tables in fdhdata in Fraud, AML and Security Intelligence

Privileges for all tables in fdhdata

Re: Privileges for all tables in fdhdata