[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Using other table for sbi users?  XML
Forum Index » Technical Help - SpagoBI Server - CORE
Author Message
dimka08.spw

Newby

Joined: 24/06/2011 15:29:13
Messages: 16
Offline

I need use users not only from table sbi_user.
From my_user, for example.
Structure of my user like sbi_user.
I want use view like
select * from sbi_user
union all
select * from my_user
Is it possible?

This message was edited 1 time. Last update was at 10/08/2011 16:30:13

vectorr3.spw

Newby

Joined: 02/08/2011 13:49:02
Messages: 11
Offline

Hi, which DBMS are you using?

If you are using PostgreSQL you can rename sbi_users to sbi_user_original, create a view called sbi_users (like your query) and write some rules to give CRUD power to the view.

Regards
Agustín

This message was edited 1 time. Last update was at 10/08/2011 19:39:54

dimka08.spw

Newby

Joined: 24/06/2011 15:29:13
Messages: 16
Offline

vectorr3.spw wrote:Hi, which DBMS are you using?

If you are using PostgreSQL you can rename sbi_users to sbi_user_original, create a view called sbi_users (like your query) and write some rules to give CRUD power to the view.

Regards
Agustín

Hi.
Tnx for help.
I using PostgreSQL now and mb Oracle.
I understand update rules for PostgreSQL and instead off for Oracle.
But i hope SpagoBI has standart method for this.
Today postgres tomorrow msserver or my sql.
In Pentaho, for example, i can change select statement in config file.
And i c statements.xml in webapps\SpagoBI\WEB-INF\conf\config\
Maybe i can add my statement for sbi_user(select only) and use it?
angioia

SpagoBI hero
[Avatar]

Joined: 12/04/2010 15:41:11
Messages: 562
Location: Milan, Italy
Offline

It's a strange requirement. Can you give me some more informations on why you want to read users from two tables. Maybe with a better understanding of the rationale behind your requirement I can help you better.

AG

Andrea Gioia
-------------------------
@andrea_gioia
@geobinitiative
-------------------------
[WWW]
dimka08.spw

Newby

Joined: 24/06/2011 15:29:13
Messages: 16
Offline

angioia wrote:It's a strange requirement. Can you give me some more informations on why you want to read users from two tables. Maybe with a better understanding of the rationale behind your requirement I can help you better.
AG

I have users management in other system and I want get user login, password and rights online from it. I can use ETL, but i want realtime
scamuzzo

SpagoBI friend
[Avatar]

Joined: 17/12/2010 17:57:48
Messages: 50
Offline

The most appropriate solution to your requirement is to configure Single Sign On and to implement a Java connector to retrieve user values from your existing security environment. Find more info on SpagoBI wiki.

Thanks

Stefano Scamuzzo
SpagoWorld
 
Forum Index » Technical Help - SpagoBI Server - CORE
Go to:   
Powered by JForum 2.1.9 © JForum Team