First of all connect with database as sysdba with sys user.
By using cmd:
C:\> sqlplus sys/oracle as sysdba
connected to:
(edition detail)
SQL>
user altered.
In above query, alter is keyword used to change, here used to change user, user is also keyword, scott is name of user or schema, identified by is keyword used for password, tiger is password for scott schema unlock is instruction for alter query.
we can lock or unlock user by using above query,
To lock user, just write above query as
SQL> alter user account scott identified by tiger account lock;
user altered.
Now account is locked.
yar acha likhta ho
ReplyDeleteenglish achi ha
hHHhHahahah. Health Magazine English e check krna. Query sa apka kia kam. is sa health theeek ni hoti.
ReplyDelete