SYS_DEL_FORBIDDEN_RULE

说明

删除一条用户登录规则

警告

权限说明: 要求当前连接用户是超级用户

语法

sys_del_forbidden_rule ::=

sys_del_forbidden_rule ::=
    SYS_DEL_FORBIDDEN_RULE ( rule_id );

参数

rule_id

需要删除的用户登录限制规则ID (INT类型)

返回值

返回：TURE/FALSE

示例

示例1: 删除一条用户登录限制

SQL> SELECT * FROM LOGIN_FORBIDDEN_RULE;
START_TIME | END_TIME | RULEID | USERID | IP | MASK
------------+----------+--------+--------+----+------
09:40:00   | 09:45:00 |  35444 |      0 |    |
10:05:00   | 10:10:00 |  35447 |  35445 |    |
(2 rows)

SQL> SELECT SYS_DEL_FORBIDDEN_RULE(35444);
SYS_DEL_FORBIDDEN_RULE
------------------------
t
(1 row)

SQL> SELECT * FROM LOGIN_FORBIDDEN_RULE;
START_TIME | END_TIME | RULEID | USERID | IP | MASK
------------+----------+--------+--------+----+------
10:05:00   | 10:10:00 |  35447 |  35445 |    |
(1 row)