요청한 작업을 수행하는 중 데이터베이스 경고 발생:
ORA-28002: the password will expire within 7 days
28002. 00000 - "the password will expire within %s days"
*Cause: The password of the user's account has expired. Since the user's
account is associated with a password profile with a limited
password grace period and grace period is yet to elapse, the user
will not be prompted to input a new password and ORA-28002 warning
message will continue to be displayed upon each successful login
to the user account, until the user changes their password.
Once the grace period elapses, the password will expire and user
login will start failing with ORA-28001 error, until the user
changes their password.
*Action: Change the password or contact the database administrator.
업체 코드 28002
select * from dba_users;
alter user 계정이름 IDENTIFIED by 새비밀번호;
'Programming > Sql' 카테고리의 다른 글
[DB] Primary Key 와 Foreign Key (0) | 2021.04.02 |
---|---|
테이블에 컬럼 추가하기 (0) | 2021.01.19 |
SQL - 7 서브쿼리 - 다중행 서브쿼리 (0) | 2020.10.17 |
SQL - 6 서브쿼리 - 단일행 서브쿼리 (0) | 2020.10.17 |
SQL - 5 조인 (0) | 2020.10.17 |
댓글