1 批量锁用户--数据库迁移后不允许在连接了
SELECT 'alter user '||username||' account lock;' from dba_users WHERE username NOT IN ('SYS','UUFS_2020')
AND account_status='OPEN';
alter user wjxyxg account lock;
2 解锁
alter user scott account unlock;
2023-03-10编程教程下载本文Oracle,用户,解锁
1 批量锁用户--数据库迁移后不允许在连接了
SELECT 'alter user '||username||' account lock;' from dba_users WHERE username NOT IN ('SYS','UUFS_2020')
AND account_status='OPEN';
alter user wjxyxg account lock;
2 解锁
alter user scott account unlock;
《oracle 锁用户和解锁。.doc》
下载本文的Word格式文档,以方便收藏与打印。