oracle11g creating new users and modifying the maximum number of connections

Create user test identified by Root;grant create Session,resource to Root;alter user test account Unlock;grant CREATE view To test;grant all sequece to test;grant create synonym to ich;--the privilege of creating aliases drop user test cascade; connection user min case-insensitive alter system SE T sec_case_sensitive_logon=false scope=both;commit; Modify the user's password alter users system identified by system;

Sequece Test_seq created in user 1 if you want to use in User 2 (select Test_seq.nextval from dual) must now perform select Test_seq.nextval from Dual;o in user 2 Racle a complete procedure for creating a user, creating a tablespace, authorizing, and building a table 1. Log in to SQL Plus with SYS:    usename:sys as sysdba    Password: ****2. To view the maximum number of connections: Select value from V$parameter where name= "process Es "; 3. View the current number of 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