查看当前登录用户相关
#su - oracle
#sqlplus /nolog
SQL> conn testusername/testuserpwd@sid; -- 或者: conn testusername/testuserpwd@IP地址:端口号/数据库实例;
select * from user_tab_privs; -- 拥有权限的表
查看表或者用户的创建信息
SQL> conn system/system的密码@IP地址:端口号/数据库实例
select owner, object_name, created, timestamp, last_ddl_time from ALL_OBJECTS where OBJECT_TYPE='TABLE' and OWNER='xxxx';
select username, created from dba_users WHERE username='xxxxx' or username='xxxx';