Re: Set Role in Trigger

2003-08-01 Thread Jared . Still
ents of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Set Role in Trigger Hi! Just try it out in test env... There's gonna be a lot of compiling, inserts on source$, idl_ub1$ and idl_sb4$ tables (actually more tables such are procedure$, access$, obj$ etc..)

Re: Set Role in Trigger

2003-08-01 Thread Tanel Poder
ers sounds kind of interesting. > > Jared > > > > > > [EMAIL PROTECTED] > Sent by: [EMAIL PROTECTED] > 07/31/2003 10:59 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: >

Re: Set Role in Trigger

2003-07-31 Thread Jared . Still
59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: Set Role in Trigger Jared, Yeah, I'm sure our Developers complain to their boss "That dang DBA's Jacking with my application

Re: Set Role in Trigger

2003-07-31 Thread JApplewhite
<[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> om> cc:

Re: Set Role in Trigger

2003-07-30 Thread Jared Still
.935.5929 (pager) > [EMAIL PROTECTED] > > > > >

Re: Set Role in Trigger

2003-07-30 Thread JApplewhite
[EMAIL PROTECTED] d.tenet.edu To: Multiple recipients of list ORACLE-L <[E

RE: Set Role in Trigger

2003-07-28 Thread Pardee, Roy E
ck C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] "Arup Nanda" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/27/2003 01:24 PM Please respond to ORACLE-L To:

Re: Set Role in Trigger

2003-07-27 Thread Arup Nanda
ll trigger this role setting event; could you elaborate on that?   I really HTH.   Arup Nanda www.proligence.com - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Sunday, July 27, 2003 8:59 PM Subject: Re: Set Role in Trigger Arup

Re: Set Role in Trigger

2003-07-27 Thread JApplewhite
lt;[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/27/2003 01:24 PM Please respond to ORACLE-L                 To:        Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>         cc:                 Subject:        Re: Set Role in Trigger Jack,   Question - why do you want

Re: Set Role in Trigger

2003-07-27 Thread Tanel Poder
Hi! Yep, security wise this solution was not good, Apps uses acutally dbms_application_info.set_client_info procedure (which sets client_info column i v$session). That's quite old mechanism, but yeah, one could set anything for it's value (although IIRC, Apps user had to execute it through fnd_app

Re: Set Role in Trigger

2003-07-27 Thread Arup Nanda
I am not an expert on Oracle Apps, but those "session environment variables" are probably application context attributes I mentioned earlier. They can also be implemented by a package global variable; but there is no security in that; the user will be able to set the variable in anyway he wants. Ye

Re: Set Role in Trigger

2003-07-27 Thread Tanel Poder
Hi! > This is probably too kludgy or simple-minded, or non-maintainable, but is it technically possible? > > 1) Create a series of views that subset > the actual tables, according to the rules > you've got about who the viewer is & what > year(s) they've selected in the Users table. >

Re: Set Role in Trigger

2003-07-27 Thread Arup Nanda
Technically possible, but prpbably not practical. You have to create several views for each of the users; possible - but may become unmaintainable. FGAC may be a btter maintanable option, IMHO. Arup Nanda www.proligence.com - Original Message - To: "Multiple recipients of list ORACLE

RE: Set Role in Trigger

2003-07-27 Thread Pardee, Roy E
This is probably too kludgy or simple-minded, or non-maintainable, but is it technically possible? 1) Create a series of views that subset the actual tables, according to the rules you've got about who the viewer is & what year(s) they've selected in the Users table. 2) Redefine

Re: Set Role in Trigger

2003-07-27 Thread Arup Nanda
[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Sunday, July 27, 2003 11:59 AM Subject: Set Role in Trigger Short form of my question: How can I enable a Role for a User within a database trigger (owned by another Schema) on a table owned by yet another Sc

Set Role in Trigger

2003-07-27 Thread JApplewhite
Short form of my question: How can I enable a Role for a User within a database trigger (owned by another Schema) on a table owned by yet another Schema? - The M's I've RTF'd indicate that a trigger (and any procedure it calls) can never execute with Invoker's Rights. - I can't find a way to execu