Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 'Big' doubt...

Re: 'Big' doubt...

From: <fitzjarrell_at_cox.net>
Date: 17 May 2007 13:02:47 -0700
Message-ID: <1179432167.585325.113250@e65g2000hsc.googlegroups.com>


On May 17, 2:24 pm, PUNKORE8 <punko..._at_gmail.com> wrote:
> But is there another way to do that?
>
> Thanks.
>
> On May 17, 4:17 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
>
>
> > On May 17, 2:08 pm, PUNKORE8 <punko..._at_gmail.com> wrote:
>
> > > I mean return some values differently.
>
> > > For example:
>
> > > I want that dataset:
> > > id name
> > > 1 Foo Bar
>
> > > Using a user-defined function to be displayed like that:
>
> > > id name
> > > 1 Foo-Bar
>
> > > Is that possible?
>
> > > Thanks in advance.
>
> > > On May 17, 3:59 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
>
> > > > On May 17, 1:49 pm, PUNKORE8 <punko..._at_gmail.com> wrote:
>
> > > > > Can i with FGA and Regular Auditing "manipulate" datasets?
>
> > > > Define '"manipulate" datasets'.
>
> > > > David Fitzjarrell- Hide quoted text -
>
> > > - Show quoted text -
>
> > Not with FGA, as far as I know. FGA is used to restrict access to
> > certain data and to log access attempts to that data. It doesn't
> > reformat the output.
>
> > Go tohttp://www.psoug.org/library.htmlandlook at the examples
> > provided for FGA.
>
> > David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -

Not 'automagically' as far as I know. There is no such thing as a SELECT trigger (from which you'd format such output). You could write an application to do such a task, and force your end-users to access the database only through your application. Possibly someone else could think of something, but I'm at a loss to implement what you want triggered by a SELECT.

David Fitzjarrell Received on Thu May 17 2007 - 15:02:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US