Create a new user simple edition for a database in Suse Linux

Create a new user simple edition for the database in Suse Linux. first, you need the root permission to log on to the database, sqlplus sys/sys @ oracle_ip 2. create user username identified by password. now, log out of the root user and use sqlplus username/password @ oracle_ip to log on with the new user name. 4. the First Login will prompt that there is no question about the session. In this case, you need to add the session to your user, grant create session to username; 5. after the session is added, log on again. create table table_name will find that you are not authorized to create the table. In this case, you need to log on to root, sqlplus sys/sys @ oracle_ip again, and then add permissions to your users. 6. Once and for all, add the DBA permission to your user, grant DBA to username; of course, if you do not want to, you can only add the table creation permission, grant create table to username;