[转] oracle限制用户在某个时间段内禁止登录数据库

最新推荐文章于 2024-03-18 17:59:28 发布

CODE CAMPING

最新推荐文章于 2024-03-18 17:59:28 发布

阅读量406

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签：数据库

本文链接：https://blog.youkuaiyun.com/iteye_5430/article/details/82603198

数据库专栏收录该内容

13 篇文章

订阅专栏

本文介绍了如何在Oracle数据库中创建一个触发器来限制特定用户的登录时间。通过使用SYSDATE函数结合条件判断，该触发器能够阻止指定用户在上午8点到晚上10点之间登录数据库。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[size=small]原文: http://blog.itpub.net/29371470/viewspace-1081319/
[oracle@rhel ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Sat Feb 8 12:51:15 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create user lsq identified by lsq;
User created.
SQL> grant connect, resource to lsq;
Grant succeeded.
SQL> conn lsq/lsq
Connected.
SQL> disc
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> conn / as sysdba
Connected.
SQL> CREATE OR REPLACE TRIGGER limit_connection
2 AFTER LOGON ON DATABASE
3 BEGIN
4 IF USER = 'LSQ' THEN
5 IF to_number(TO_CHAR (SYSDATE, 'hh24')) BETWEEN 8 AND 22
6 THEN
7 RAISE_APPLICATION_ERROR(-20998,' Dear user '||USER||'! You can''t login between 08 and 22');
8 END IF;
9 END IF;
10 END limit_connection;
11 /
Trigger created.
SQL> select to_char(sysdate,'hh24') from dual;
TO
--
12
SQL> conn lsq/lsq
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-20998: Dear user LSQ! You can't login between 08 and 22
ORA-06512: at line 5
Warning: You are no longer connected to ORACLE.[/size]