Sorry, if my mail is not clear. I have assigned privs thru roles only. I
need a report of that in the format I mentioned.

The script I have now gives in this format :

Role object_name Privs

Readwrite emp select
emp insert
emp update

But, I need in the following format :

Readwrite emp select,insert,update

TIA,

Sreenu



>From: "Ruel Rodriguez" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Re: script for priv/roles
>Date: Thu, 31 Oct 2002 15:02:57 -0800
>
>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 documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] 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


_________________________________________________________________
Broadband? Dial-up? Get reliable MSN Internet Access.
http://resourcecenter.msn.com/access/plans/default.asp

Oracle LazyDBA home page