3 Replies Latest reply on Feb 13, 2015 2:43 PM by Christian Berg

    how to provide authentication distinctly by each user for same physical set of tables

    Amol Palkar

      I have scenario here, basically we are trying to implement authorization and authentication based on individual user who are sharing same set of database tables but their data is different.

       

      Say suppose we have 3 differnt schema in the database containing same tables , this has been accessed by 3 different users.

      When it comes to database , we created only one physical model for the same because due to heavy number of tables so we could not create 3 same physical models to provide 3 different database access in the connection pool. For avoiding that we need to have only one physical model but now the problem is that what is the way to put in the Init Block in order to initialize session variable of user table ?

       

      This is concerned to authentication ultimately achieving authorization.

       

      I hope you understood the situation.

       

      Thanks....