Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

function security on Answers

707781Oct 9 2009
Hi, I wanna know is it possible to do this. thanks!!

if userA can view requests (requests stored in a subfolder called "sharedA" under "Shared Folders") on dashboards.

userA also has rights to access Answer to build his own requests but to stored in another subfolder "sharedX"

under "Shared Folders".

userA cannot edit requests stored in "sharedA".

I found that when userA accesses Answers, he can read the "sharedA" requests although he cannot edit.

is it possible to force userA not able to read the "sharedA" requests in Answers?

Thank you very much!

Comments

Russ Proudman
Well if you mean, can Discoverer look at tables / views on a SQL server then yes, I believe you can make a connection such as odbc or jdbc. However, not all SQL functions will be supported as Oracle has some of it's own whereas the protocol standards would only be supported.

If you mean can Discoverer run on the SQL server (ie: EUL tables, etc.), then no.

Russ
SteveF-Oracle
To add to what Russ stated.

You have to install the EUL on Oracle DB, then use Heterogenous Services (ODBC connectors) connectivity from Oracle DB to non-Oracle DB.

It is covered in the Adminstrator Guide in pretty good detail
http://download-west.oracle.com/docs/html/B13916_04/rdb_support.htm#CIHJEJBB
23 Discoverer support for non-Oracle databases and Oracle Rdb

Regards,

Steve.
Russ Proudman
And one thing I'm just passing by all, is the quote about non-Oracle database using / not using ODBC drivers.

This question came up a while ago and I quoted the manual saying that if you use ODBC drivers, then the EUL could be in the non-Oracle database.

After lotsa' posts, etc. it was decided that the documentation was wrong. Whether or not you use ODBC, you cannot have the EUL in a non-Oracle database.

Just passing this on as the manual differs.

Russ

=========================================================
quote from manual:

What is the difference between using generic connectivity and ODBC drivers to connect to non-Oracle databases?

In previous versions of Discoverer, users could connect to non-Oracle databases using ODBC drivers. The major difference between using ODBC drivers to connect to a non-Oracle database and using the Oracle database generic connectivity feature is the location of the EUL, as follows:

with ODBC drivers, the EUL is stored in the non-Oracle database

with generic connectivity, the EUL is stored in the Oracle database

===========================================================
1 - 3
Locked Post
New comments cannot be posted to this locked post.