create user xx identified by password;
grant create session to xx; grant select on USER to xx; grant select on PAYMENT to xx; grant select on COMPANY to xx;
select * from user_tab_privs where grantee = 'xx'
select * from sys.all_tables; select * from sys.all_synonyms; select * from sys.all_views;
|