Oracle database assigns one user to query all tables in another user

Description: Enables user selame to query all tables in user ame (cannot be added and deleted)
1. Create User Selame
Create user selame identified by Password;
2. Set User Selame system permissions
Grant Connect,resource to Selame;

3. Set user Selame object permissions

Grant Select any table to "Selame";

Grant Grant unlimited to "Selame";

4. Execute the following statement

Select ' Grant select on Ame. ' | | table_name| |; To Selame, ' from All_tabels where lower (owner) = ' ame ';

* Below is a table that says you have to assign a value

5. Put the table above saying there is a value to be assigned. Execute it again

such as: Grant Select on AME. D60512017 to Selame;

6. Execute the COMMIT statement

Commit

7. Exit

Quit

8. Log in to the database with user Selame

9. Enquiry Form

SELECT * FROM AME. D60512017;

* "Unselected rows" error if there are no records in the table

The number of record bars in the query record table--select count (*) from AME. D60512017;

View table Structure--desc ame. D60512017;

Insert record--insert into ame.60512017 values (1,1,1,1,1,1);

Query users--show user;

Oracle database assigns one user to query all tables in another user