Oracle常用sql命令

Updated on with 0 views and 0 comments

查看锁定次数上限

SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES WHERE RESOURCE_NAME = 'FAILED_LOGIN_ATTEMPTS'

image.png

用户解锁

PS: 由于密码错误次数超过限制次数出现用户锁定情况

alter user user_name account unlock

用户授权

alter user HSE quota unlimited on users;

表授权

grant select,insert,update,delete,all on 表 to 用户

标题:Oracle常用sql命令
作者:sirwsl
地址:https://www.wslhome.top/articles/2022/04/12/1649732960887.html