Grant SELECT on multiple tables oracle

select oracle11g grant
Sergio Martinez picture Sergio Martinez · Mar 16, 2013 · Viewed 130.6k times · Source

I have 3 tables table1,table2,table3. I want to grant(select for example) these tables to a user, user1.

I know that I can grant with: 

grant select on table1 to user1;
grant select on table2 to user1;
grant select on table3 to user1;

Can I grant the 3 tables to user1 using only 1 query?

Thanks

Answer

Chris Saxon picture Chris Saxon · Mar 16, 2013

No. As the documentation shows, you can only grant access to one object at a time.

Related questions

How can I select from list of values in Oracle

I am referring to this stackoverflow answer: How can I select from list of values in SQL Server How could something similar be done in Oracle? I've seen the other answers on this page that use UNION and although this …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
Selecting multiple columns in a pandas dataframe

I have data in different columns but I don't know how to extract it to save it in another variable. index a b c 1 2 3 4 2 3 4 5 How do I select 'a', 'b' and save it in to df1? I tried df1 = df[…

Read More