PROTECTED VIEW FOR CRM DATABASE

PROBLEM TO BE SOLVED: To provide a protected view for a customer relation management CRM database. SOLUTION: For example, a user can log on DBMS by using an integrated DBMS/operating system authentication protocol to get an access right to an instance of an application database. However, further access to an object included in the database cannot carried out beyond database view. A model can acquire list display of view identifiers and to allow access to the view only for executing the view. The view works as a protected proxy for a specific table in the database. A simple query condition for matching a role and a right of the user with table/line association and a privilege is given to the view. COPYRIGHT: (C)2006,JPO&NCIPI