Des2K and Forms - Table Ownership
Date: 1995/10/06
Message-ID: <DG1H6H.2wt_at_iglou.com>#1/1
I am using Designer 2000 Module Data Diagrammer to generate forms. At my company, all productions tables are owned by a single user (PROD). In Designer 2K, I work under my own id, but when running the DDL to generate the tables, I sign on as PROD. When I try to generate a form as myself, I get the error 'PL/SQL error 356 <table_name> must name a table to which the user has access'. To get around this, I generate all my forms as PROD. I believe all my roles and grants are set up properly. I double checked user_role_privs and role_tab_privs. I am in a group that has full access to these tables.
ORACLE said this should not be a problem. I was told the forms generator would use the public synonyms instead of the real table names. Received on Fri Oct 06 1995 - 00:00:00 CET