Can i with FGA and Regular Auditing "manipulate" datasets?

On May 17, 1:49 pm, PUNKORE8 <punko...@gmail.com> wrote:
> Can i with FGA and Regular Auditing "manipulate" datasets?

Define '"manipulate" datasets'.


David Fitzjarrell

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?


fitzjarrell@cox.net wrote:
> On May 17, 1:49 pm, PUNKORE8 <punko...@gmail.com> wrote:
> > Can i with FGA and Regular Auditing "manipulate" datasets?
>
> Define '"manipulate" datasets'.
>
>
> David Fitzjarrell

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...@cox.net" <fitzjarr...@cox.net> wrote:
> On May 17, 1:49 pm, PUNKORE8 <punko...@gmail.com> wrote:
>
> > Can i with FGA and Regular Auditing "manipulate" datasets?
>
> Define '"manipulate" datasets'.
>
> David Fitzjarrell

On May 17, 2:08 pm, PUNKORE8 <punko...@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...@cox.net" <fitzjarr...@cox.net> wrote:
>
>
>
> > On May 17, 1:49 pm, PUNKORE8 <punko...@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 to http://www.psoug.org/library.html and look at the examples
provided for FGA.


David Fitzjarrell

But is there another way to do that?

Thanks.

On May 17, 4:17 pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
> On May 17, 2:08 pm, PUNKORE8 <punko...@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...@cox.net" <fitzjarr...@cox.net> wrote:
>
> > > On May 17, 1:49 pm, PUNKORE8 <punko...@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.htmland look at the examples
> provided for FGA.
>
> David Fitzjarrell

On May 17, 3:24 pm, PUNKORE8 <punko...@gmail.com> wrote:
> But is there another way to do that?
>
> Thanks.
>
> On May 17, 4:17 pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
>
>
>
> > On May 17, 2:08 pm, PUNKORE8 <punko...@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...@cox.net" <fitzjarr...@cox.net> wrote:
>
> > > > On May 17, 1:49 pm, PUNKORE8 <punko...@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 -

Can you add a view on top of the table and hide the transformation
logic behind it?

On May 17, 2:24 pm, PUNKORE8 <punko...@gmail.com> wrote:
> But is there another way to do that?
>
> Thanks.
>
> On May 17, 4:17 pm, "fitzjarr...@cox.net" <fitzjarr...@cox.net> wrote:
>
>
>
> > On May 17, 2:08 pm, PUNKORE8 <punko...@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...@cox.net" <fitzjarr...@cox.net> wrote:
>
> > > > On May 17, 1:49 pm, PUNKORE8 <punko...@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

Valentin Minzatu wrote:

> Can you add a view on top of the table and hide the transformation
> logic behind it?

Only with an extraordinarily inefficient view such as one built like
this:

CREATE VIEW v AS
SELECT function_call(param), function_call(param)

I would suggest looking at using a pipelined table function instead.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On May 17, 9:58 pm, DA Morgan <damor...@psoug.org> wrote:
> Valentin Minzatu wrote:
> > Can you add a view on top of the table and hide the transformation
> > logic behind it?
>
> Only with an extraordinarily inefficient view such as one built like
> this:
>
> CREATE VIEW v AS
> SELECT function_call(param), function_call(param)
>
> I would suggest looking at using a pipelined table function instead.
> --
> Daniel A. Morgan
> University of Washington
> damor...@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

I was thinking more on the lines of a view like:
CREATE VIEW v AS
SELECT id, TRANSLATE(name, ' ', '-')
FROM <original_table>
(my understanding is the application code cannot be changed, otherwise
there is no need for a view)