?
Solved

Connecting from Hyperion Intelligent Client to a secure Access Database (User Level Security)

Posted on 2006-06-02
7
Medium Priority
?
526 Views
Last Modified: 2008-02-01
I've developed a database where I have implemented User Level Security.  I can open the database fine and the workgroup security is working fine.  However, I have users who want to access the database via BRIO (otherwise known as Hyperion).  I created a system DSN ODBC connection.  In this connection I set up a user name and password to open the database.  I've attempted to create an OCE connection to the database from Hyperion via this ODBC connection but I am unable to access the database.  I get a message stating that I have no permission to enter the database.  I've had little experience with Brio, but I would think that I should be able to access a secured Access database from Brio.  Any ideas or pointers.  I wasn't sure where to place this question and so I hope I placed it in the correct area.
0
Comment
Question by:chtullu135
  • 4
  • 3
7 Comments
 
LVL 58

Expert Comment

by:harfang
ID: 16821529
Hello chtullu135

I believe this is the right place, yes. You created an ODBC connection, but you did not mention your workgroup information file. For this to work, you will need to connect to it. Can you try the connection from some more familiar program?

(°v°)
0
 

Author Comment

by:chtullu135
ID: 16822240
I will try your suggestion.  I've been trying to think of how to have Brio use the workgroup file to verify that the Logon Id and password correspond to the existing user account that is residing in the workgroup file.  I think what I'm trying to do is tell brio to access the secured database using a specified workgroup file.  I'm won't be back at the office until Monday, but I'll do more research.
0
 
LVL 58

Expert Comment

by:harfang
ID: 16822336
chtullu,

You should be able to select the workgroup information file when you create the ODBC data source. It would make no sense to store a user name and password if that option was not availble. On my version, it's right below the selection of a database, with either "no WIF" or  "specify WIF". If Brio uses the ODBC connection by name, it won't need anything  else.

Good luck!
(°v°)
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

Author Comment

by:chtullu135
ID: 16823473
I will give that a try.  When I created the ODBC file I specified the database itself as the ODBC datasource.  You're say taht I need to also specify the workgroup file itself.  I'll double check.  When running the ODBC wizard from the control panel, I didn't see an option for selecting the Workgroup Information File.  
0
 

Author Comment

by:chtullu135
ID: 16833617
I didn't see a selection for wif or no wif in during the ODBC wizard.  I'll check again
0
 

Author Comment

by:chtullu135
ID: 16833956
I experimented a bit more and came up with the following solution
1. In the ODBC Setup Wizard, in the database section, I clicked the Select button and browsed to secured database in order to select it .
2. In the system database section of the ODBC setup dialog box, I navigated to the workgroup file and selected it
3. I then clicked the Advanced button and entered the required username and password.
4. I then save the DSN and exited the control panel.
5. I then created the Brio OCE connection as normal, and I was able to access the secured database.


I'm going to test this solution again. just to make sure
0
 
LVL 58

Accepted Solution

by:
harfang earned 1500 total points
ID: 16834694
Hello chtullu135

I'm glad you found it. I had read your previous comment and was trying to figure out how to setup a  test environment. I knew the option to select the WIF was there somewhere, but could not find a step-by-step (or do it here).

I hope this works, now. Good luck!

(°v°)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question