Re: HELP: Row Level Security

In article 12976_at_scammell.ecos.tne.oz.au, pcm_at_scammell.ecos.tne.oz.au (Peter) writes:
>
> Hello,
>
> I wish to restrict users to accessing certain rows in a
> table without using Trusted Oracle. Users would be
> accessing the table through ODBC. Does anyone have
> any ideas on how I might do this? Could I somehow use
> stored procedures containing SQL to restrict access and
> only provide the procedure SELECT access to the tables
> and only allow users access to the procedure?
>
> Any help would be REALLY appreciated!! :)
>
> Thanks, Peter.
>
> +-----------------------------------------------------------------------+
> | Peter C. Murray: I hear the apes howl sadly in dark mountains, |
> | The blue river runs swiftly through the night. |
> | class Disclaimer : public StdDisclaimer { /* It was all my fault */ };|
> | |
> | Information Technology Group, Telecom (Telstra) Australia |
> +-----------------------------------------------------------------------+

I think the easiest thing would be to create a view that contains the rows you want the users to access and then grant access to the view, not the underlying tables.

Beverly

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
+                                    +                             +
+  Beverly Cather Zygmunt            +  Phone: (615) 574-1007      +
+  Oak Ridge National Laboratory     +  email: zygmuntbc_at_ornl.gov  +
+  Building 4500N, MS 6274           +         bzy_at_ornl.gov        +
+  Oak Ridge, TN 37831-6274          +                             +
+                                    +                             +
+                                    +                             +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+                                                                  +
+  "If you torture your data long enough, they will tell you what  +
+  you want to hear." -- James L. Mills                            +
+                                                                  +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++