Dynamic Permissions and SaaSDB

I would say that using Dynamic Permissions in the SaaS project can be a bit cumbersome. If you must to use Dynamic Permissions you need to move permisions tables to the each user's database (as opposed to the main database). Each user will have their own set of permissions table. You just need to make sure that these tables are also created and populated with the initial settings when you create a database for the new user.

SAAS APPLICATION DESIGN - MULTITENANT

For inspiration purposes only, as it seems that the keyword "multitenant" is coming nearest to the requirements.

I did move the permissions to the users database, but I guess my questions is there is view table that allows admins the user to assign different group level i.e. Managers etc. That view shows all the users in the tenancy database which has to be seperate. Wondered is there a way to filter this view to only show that customers database users. I hope this makes sense?

Here is the an idea of what you can try. Modify the SQL query of users table this way:

select ... from users <? where dbname = :session.dbname ?>

<? and ?> wrappers are required to make this where clause appear only when this session variable is populated.

Also, after changing this SQL query you need to turn Dynamic Permissions off and on again as this SQL query will be copied to Dynamic Permisions tables when you enable this feature.

I will try this and let you know ... thanks Sergey