oracle 限制特定用户连接数

限制csuser的连接数为1

SQL> create profile limit_csuser limit sessions_per_user 1;

Profile created

SQL> ALTER USER csuser profile limit_csuser;

User altered

SQL> alter system set resource_limit=true;

System altered

SQL>