分类: Oracle
2010-06-08 17:01:17
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL> col username for a15
SQL> select username,password,account_status from dba_users where USERNAME='MGMT_VIEW';
USERNAME PASSWORD ACCOUNT_STATUS
--------------- ------------------------------ --------------------------------
MGMT_VIEW A2C9C472AEB0438C OPEN
SQL> select object_name,object_type from dba_objects where owner='MGMT_VIEW';
no rows selected