sqlplus :
查看当前连接的用户: show user
切换用户: connect username/password@db
查看某一用户的表: select table_name from dba_tables where owner=username(注意大小写)
查看所有当前用户可以访问的表: select table_name from all_tables
查看所有用户: select * from dba_users;
查看表结构: (sqlplus中)desc tableName;