Oracle锁定用户、删除用户、创建用户

  • A+
所属分类:数据库

(1).锁定用户

sql>alter user <username> account lock;

(2).删除用户

sql>drop user <username> cascade;

(3)创建用户:

sql>create user <username> identified by <password>;

(4)查看用户是否锁定:

sys@COREDB>select username,account_status from dba_users where not account_status = 'OPEN';

avatar

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: