如何设计某个帐号只能允许一个人同时使用

而且这个人一旦断开,能够及时通知服务器
---------------------------------------------------------------

写一个触发器,设置标志位!
至于“而且这个人一旦断开,能够及时通知服务器“
需要客户端的控制!
---------------------------------------------------------------

ALTER PROFILE p1 LIMIT SESSIONS_PER_USER 1;

assign p1 to that user: ALTER USER scott
PROFILE p1
---------------------------------------------------------------

ALTER PROFILE p1 LIMIT SESSIONS_PER_USER 1;

assign p1 to that user: ALTER USER scott
PROFILE p1

this is the only way: ofcourse 一次只能一个用户使用.
the second user can not get connected .

oracle has a session concept , the session is kept openning between client and server .

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus