Ashish,

If you're on 8i+ consider using RLS (Row-Level
Security) aka FGAC (Fine Grained Access Control) aka
VPD (Virtual Private Database). Pretty cool stuff.

See Note: 99250.1 "Understanding Fine-Grained Access
Control (DBMS_RLS) on INSERT"

HTH,

-- Anita

--- Ashish Shah <[Email Address Removed] wrote:
> Hi All,
>
> Is it possible to create schema level trigger
> where you can restrict user to update/delete/insert
> rows in certain tables.
>
> I know you can have such trigger for alter,drop
> kinda
> thing where I can restrict user from doing so
> however
> I can do it using system account.
>
>
> Any ideas?
>
> Thanks
>
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute
> with Yahoo! Messenger
> http://phonecard.yahoo.com/
>
> --------
> Oracle documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit the list archive:
> http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about http://www.farAwayJobs.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
Oracle LazyDBA home page