Permissions of a user/group
Hi,
I have users grouped into groups and permissions to each of the project folders are assigned to groups. Is there a way to query the list of folders a user / group has access and the permissions...
Forum Discussion
@robin Thank you so much!
I do have a following question regarding to dynamic databases.
What if I have different types of dbs (Oracle, MS-SQL etc) ? Can I use one pipeline to connect all of them?
My assumption is no, because each type of snap could only work for specific type of database. Oracle snap could only work for oracle; MySQL snap could only work for MySQL etc.
How about files? Can I use a pipeline to read either csv or xlsx file? I am guessing no because I tried csv parser would not work on xlsx files and vice versa.
What if I have different types of dbs (Oracle, MS-SQL etc) ? Can I use one pipeline to connect all of them? My assumption is no, because each type of snap could only work for specific type of database. Oracle snap could only work for oracle; MySQL snap could only work for MySQL etc.
Well we have a JDBC Snap Pack that is designed for generic database operations but a fully dynamic configuration for a wide variety of databases probably wouldn’t be what I would recommend.
Instead you could consider (for both multi-database and multi-filesystem scenarios) a routed-parent-child pipeline approach by using the Router Snap and then a Pipeline Execute (“PipeExec”) Snap.
The Router would examine some field’s value (e.g. db_name or file_protocol) to determine what DB engine or file type was being used and then route the document flow to a Pipe Exec Snap that would call a particular child pipeline that was designed for dynamic configuration for that particular database, filesystem or file type.
It would look something like this:
Perhaps give it a try and see what you can come up with.
