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..)
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:
>
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
<[EMAIL PROTECTED]To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
om> cc:
.935.5929 (pager)
> [EMAIL PROTECTED]
>
>
>
>
>
[EMAIL PROTECTED]
d.tenet.edu To: Multiple recipients of
list ORACLE-L <[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:
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
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
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
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
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.
>
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
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
[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
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
16 matches
Mail list logo