granting select on many tables at many schems

we have few developers that will need select on many schemas,
we are not sure which shcema and which tables.
at the same time we do not want to grant select any table what to do?
LVL 11
it-rexAsked:
Who is Participating?
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
>>we have few developers that will need select on many schemas,
Loging as owner: use appropriate syntax if you are using DBA account
select 'grant select on ' || TABLE_NAME || ' to developer_id ;' from user_tables where table_name in ('TABLE1', 'TABLE2', ....);
Run the above output

>>we are not sure which shcema and which tables.
This is the first info we all need.

0
 
slightwv (䄆 Netminder) Commented:
Get the list of objects and manually grant select.

If you don't know them and do not want 'any table' your options are limited.
0
 
slightwv (䄆 Netminder) Commented:
Can I ask why you gave full points to the answer you did?

Both posts state that you need to know the schemas and tables before you can do what you want.
0
 
it-rexAuthor Commented:
@slightwv
 this was a mistake I need to split these points to both answers;it has been very busy here and I was not paying attention.
I apologize,
0
 
it-rexAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.