pentaho - How to create multiple repositories in Penatho -

i know how create different (multiple) repositories in pentaho enterprise version. below points add. 1. different repositories different users, 1 user cant access other users transformations , jobs. 2. 1 user cant access db connections of other users in different repositories.

my main concern want logic here security reasons. 1 user cant access or update other users created transformation.

is possible? please me on this.

thanks in advance.

this how repos set up. use database repos on postgresql users. create new repo, click green + button @ top right of repository connection dialog.

to keep users out of each others sandboxes, create different schema each user , assign db permissions accordingly. note, schema has created before create repo. of course i'm db superuser can repos.

when create connection repo, go advanced tab , specify user's schema in 'preferred schema name' box. note, connection not appear in list of connections stored in repo; it's in repositories.xml file in .kettle directory. created template xml file can tweak give out comes on board developer. way see repo in connection dialog, repositories.xml has of repos.

you can file based repos well, of course you'd handle permissions through file system rather db.

it's true repos can have multiple users. use feature when members of same group need share transforms. example data warehouse group in 1 repo, each has own directory; other group has own repo, etc.