Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
I am upgrading from OAS to OAC. How do I setup a group authorization using a remote database table?

I am upgrading from OAS to OAC. How do I setup a group authorization using a database table, like it was possible on OAS using BI SQL Group provider?
Is there an alternative possible? The table in the remote database is currently the master of roles for OAS, and I want to keep it like that in OAC and not having to do manual work or synchronisation between this table and OAC.
BI SQL provider was exactly what I needed for OAS, I hope OAC has a worthy alternative.
Thanks!
Best Answer
-
For completeness sake here's the official documentation:
Bottom of the page:
Several security features in Oracle BI Enterprise Edition are not available in Oracle Analytics Cloud:
Database storage for user group memberships (authentication provider
BISQLGroupProvider
)1
Answers
-
Hi @Stijn Bormans
For OAC, you use Identity Domains for authentication and authorization. You can configure groups there.
see: About Users and Groups1 -
Hi @Stijn Bormans ,
Database Storage for User Group Memberships is not supported in OAC. The feature has been deprecated and might be desupported in (a future version of) OAS as well.
You have to import users, groups and memberships from your database to your OCI identity domain.
0 -
Thanks for your answers, very helpful!
0