Re: Security question

Georg Scholz wrote:

> Dear Newsgroup,
>
> Is it possible to define a view, such that the data returned is dependent of
> security settings?
>
> e.g.: if a user has some role activated, then the view should return 7
> columns, else only 6 columns.
> or: the view should return some extra rows if a role is activated.
>
> We use Oracle 8.1.7
>
> Thanks in advance
> --
> Georg Scholz
> www.scholz-informatik.at

Yes. Go to http://tahiti.oracle.com and look up SYS_CONTEXT and FINE GRAINED ACCESS or whatever Oracle has renamed it to this week.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
(remove one 'x' from my email address to reply)