sql - how to do select * from tab for a specific user -

i'm learning oracle sql. know how specify user in select * tab; statement? want able see list of tables given user.

thanks

tab pretty ancient data dictionary view. that's not should using ever if you're learning oracle sql.

you're better off querying dba_tables or all_tables data dictionary views appropriate where clause. example, if have select access on tables in question

select table_name   all_tables  owner = <<user you're interested in>>

select table_name   dba_tables  owner = <<user you're interested in>>

if don't have access tables in question have privileges access dba% tables in data dictionary.

Error