To query the Oracle user for permissions on other user tables

1. Create User User1

Create user User1 identified by xxxx

Default Tablespace xxxx_table

Temporary Tablespace Temp

Profile default

Grant connect to User1;

2, Way one: Batch table to empower

Select ' Grant select on Pposuat_17. ' | | table_name | | ' to TESTUSER_17, ' from Dba_tables where owner= ' pposuat_17 ';

Mode two, sys empowering

If you want to make read-only settings for all tables, you can grant the Select any table system permission to that user.

--Release

Revoke select on User1.tablename from User2;

This article is from the "Ahead51jie" blog, make sure to keep this source http://ahead51.blog.51cto.com/179590/1905407

To query the Oracle user for permissions on other user tables