search

DDieterich / DTGen

DTGEN Code Generation Tool for Relational Designers (See Wiki Branch)
http://dtgen.org
3 stars 0 forks source link

Mid-Tier SQL on Base (Active) Table Doesn't Work #64

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
  1. Generate and Load Test Set on OracleXE 11g Windows 64-bit
  2. Login as TMTST
  3. insert into T1A_NON (id, seq, NUM_PLAIN) values (T1A_NON_dml.get_next_id, 11, NULL);
  4. SQL Error: ORA-01031: insufficient privileges

What is the expected output? What do you see instead?

  -) This SQL should work.  It appears to be a problem with loopback database link in that the permissions for the loopback are getting confused since the object name is the same in the TMTST and TDBST schema.

Please use labels and text to provide additional information.

  -) Possible Oracle bug?

Original issue reported on code.google.com by Duane.Di...@gmail.com on 18 Sep 2012 at 5:56

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
A work-around is in place for the regression testing.  The work-around is to 
explicitly grant the needed permissions to user using the supplemental SQL 
script "grant_role_option".

Original comment by Duane.Di...@gmail.com on 4 Oct 2012 at 12:18