Create a new user and modify the maximum number of connections at oracle11g

Create a new user and modify the maximum number of connections at oracle11g

Create user test identified by root; grant create session, resource to root; alter user test account unlock; grant create view to test; grant any sequece to test; grant create synonym to ich; -- the permission to create an alias is drop user test cascade. During connection, the user is case-insensitive. alter system set sec_case_sensitive_logon = false scope = both; commit; alter user Password alter user system identified by system;

Sequece test_seq created in user 1. If you want to use (select test_seq.nextval from dual) in user 2, select test_seq.nextval from dual must be executed in user 2; oracle is a complete process of creating users, creating tablespaces, authorizing, and creating tables. 1. log on to SQL plus: usename: sys as sysdba password: ***** 2. view the maximum number of connections: select value from V $ parameter where name = "processes"; 3. view current connections: select count (*) from V $ process; 4. change the maximum number of connections to 300: alter system set processes = 300 scope = spfile5. restart DB: shutdown immediate; startup;