--查询用户状态
select * from dba_users where username='OCS';
--解锁用户
alter user OCS account unlock;
--修改用户口令
alter user ocs identified by ocs;
--用用户OCS登录后,查询该用户下的表
select * from dba_users where username='OCS';
--解锁用户
alter user OCS account unlock;
--修改用户口令
alter user ocs identified by ocs;
--用用户OCS登录后,查询该用户下的表
select table_name from user_tables;
修改大小写敏感:
select * from v$parameter where name ='sec_case_sensitive_logon'
ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE;
--锁表信息
SELECT /*+ rule */ lpad(' ',decode(l.xidusn ,0,3,0))||l.oracle_username User_name, o.owner,o.object_name,o.object_type,s.sid,s.serial#
FROM v$locked_object l,dba_objects o,v$session s
WHERE l.object_id=o.object_id
AND l.session_id=s.sid
ORDER BY o.object_id,xidusn DESC
--解锁
alter system kill session 'sid,serial#'