Hi Guys,
Can you tell me how you create database on raw partition.
means when you run the database creation command what you hav to say about partition?
Thanks

Deepak
Ruel Rodriguez <[Email Address Removed] wrote: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"
To: "LazyDBA.com Discussion"
Sent: 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



---------------------------------
Do you Yahoo!?
HotJobs - Search new jobs daily now
Oracle LazyDBA home page