It's best to control your selects with roles then you assign a role to
different users.
For example:
create user user1 identified by pwd1
default tablespace users temporary tablespace temp
quota unlimited on users quota unlimited on temp;

create user user2 identified by pwd2
default tablespace users temporary tablespace temp
quota unlimited on users quota unlimited on temp;

create role user_rd;
create role user_upd;
grant connect to user_upd;
Grant connect to user_rd;

grant user_upd to user1;
grant user_rd to user2;

You can add as many users you want to each role, you can move a user
from one role to another, or a user can even have both roles. It's very
flexible.

Then for your table access you can grant access to the roles however you
like or even generate grant statements from the catalog with something
like this:

I.e. capture & run the output from these commands

select 'grant delete, insert, update, select on ' || table_name || ' to
USER_UPD;'
from dba_tables where owner = 'schema owner'
/
select 'grant select on ' || table_name || ' to USER_RD;'
from dba_tables where owner = 'schema owner'
/


Hope this helps a bit.
Ian

-----Original Message-----
From: akki
[mailto:oracledba-ezmlmshield-x89034888.[Email address protected]
Sent: Wednesday, 6 October 2004 12:08
To: LazyDBA Discussion
Subject: HOW TO GRANT SELECT ON ALL TABLES

hi list ...
plz tell me

HOW TO GRANT SELECT ON ALL TABLES OF A PARTICULAR USER TO ANOTHER
USER..?
thanks
akki



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page