限制一个用户名可进行的连接: ALTER SYSTEM SET RESOURCE_LIMIT=TRUE 写在init文件中:RESOURCE_LIMIT=TRUE create profile low_limits limit session_per_user 1 然后把某种配置文件赋给某个用户: alter user youruser profile low_limits;然后可以查看: select profile from dba_users where username='YOURUSER'; select * from dba_profile where profile='low_limits';
ALTER SYSTEM SET RESOURCE_LIMIT=TRUE
写在init文件中:RESOURCE_LIMIT=TRUE
create profile low_limits limit
session_per_user 1 然后把某种配置文件赋给某个用户:
alter user youruser profile low_limits;然后可以查看:
select profile from dba_users where username='YOURUSER';
select * from dba_profile where profile='low_limits';