如果是非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;