In Oracle, can I give users permission to see only the specified tables and views?

cslys1979

RT
How to set it up?
Thank you for your excellent suggestion!

sanshuimei

grant select on table to user
Pay right

whbilly

A common role-role
All users with this role have specific permissions that the role has

such as:
create role r_acter_user;
grant create session to r_acter_user;
grant select on dba_users to r_acter_user;
grant create trigger to r_acter_user;
Grant this role to the user myuser; then: myuser has all the permissions that the role above has:
grant r_acter_user to myuser;

lifebloom

Database role and anti-question database must be set!

wwelaine

Create a new user, and then assign the connect role,
Then assign table permissions
grant select on table to user