1.oracle数据库中删除用户有两种命令，一种是 drop user xxx；另外一个种是drop user xxx cascade;2.官方的说明如下：Dropping a Database User: Example If user Sidney's schema contains no objects, then you ca...
1、显示用户信息（1）显示当前会话用户10:16:18 SQL> show user;USER is "SYS"（2）显示特权用户10:17:07 SQL> conn sys/oracle as sysdba;Connected.10:17:09 SQL> select * from v$pwfile_users;USERNAME...
oracle 给用户改名
http://hi.baidu.com/yuzhoublog/item/666ca0c3e2a2bb47a9ba9482
/*
update user$ set name='OLD' where name='NEW';
alter system checkpoint;
alter system flush share...
查看当前用户下有哪些对象
SELECT OBJECT_NAME,OBJECT_TYPE FROM USER_OBJECTS;
View Code
用户解锁
View Code
（1）conn sys/sys as sysdba; //以DBA的身份登录
（2）alter user scott account ...
