It would be better to create a role and assign privileges to that role and
then grant that role to your user.

Example:

Create role user_role1;
grant select, insert, update on scott.emp to user_role1;
grant user_role1 to username;

Hope this will help you.

Ruel Rodriguez
Oracle Certified Professional - Application Developer
Global Computer Associates

----- Original Message -----
From: "Sreenivas Sri" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Thursday, October 31, 2002 11:35 AM
Subject: script for priv/roles


>
>
>
>
> Gurus,
>
> Could any body send a script that gives the privileges on tables ... in
this
> format...
>
> object name privileges
>
> emp select,insert,update
> dept select
>
> Thanks,
>
> Sreenu
>
> _________________________________________________________________
> Get a speedy connection with MSN Broadband. Join now!
> http://resourcecenter.msn.com/access/plans/freeactivation.asp
>
>
> --------
> 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
>


Oracle LazyDBA home page