如果是非oracle客户端工具(pl/sql,oracle client)
先以oracle身份登录 数据库服务器,
然后 登录 :sqlplus scott/tigr as sysdba;
删除用户:drop user test CASCADE;
锁定用户:alter user test account lock; 解锁 alter user test account unlock;
创建用户并授所有权限:
CREATE USER web IDENTIFIED BY web123$;
GRANT ALL PRIVILEGES to web;
强制关闭数据库 shutdown abort
强制启动数据库 startup force