This content has been marked as final. Show 6 replies
each schema has a table USERS for authenticating users and a table USER_ACCESS to control which user could access which form or report.
now my management want to centralize these applications, means a single login screen and centralized access control. a single page for all the applications from
which a user could select a form or a report for example.
what things should i keep in mind before proceeding?
what is the methodology?
SInce the USER_Access have same structure in all the schema, add another column as "Schema_Name" then update this table with all user access with their respective schema.
Now keep this table - where user login first ... then accoriding to their user id-> you can loging internally to their schema
I hope you will get what you need !!