查看登录oracle信息,Oracle普通用户登录及查看信息

[oracle@ora-11gr2 ~]$ sqlplus /

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 10 13:00:59 2013

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:

ORA-01017: invalid username/password; logon denied

Enter user-name: hr

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> describe user_tables;

-- 查看用户表的表结构

SQL> describe tabs

--效果和上一句一样

SQL> select table_name from tabs;

-- 查看用户都有拥有那些表