1. First of all, we can use the Scott user login oracle as sysdba.
Conn Scott/tiger as sysdba
2. Then I can begin to create user.
The create user zs identified by zs.
3. Modify the user's password.
The alter user zs identified by 123456;
4. Create a table space.
The create in tablespace zs_zs datafile 'f: \ zs_zs DBF' size of 200 m;
5. Create table space, also need to assign a table space users.
The alter user zs default in tablespace zs_zs;
6. Assign user table space, the user can not login (no login permissions), so you also need to assign permissions to users
Grant create session, create table, create a view, the create sequence, unlimited in tablespace to zs.
CodePudding user response:
on the blog, later find it more convenient,CodePudding user response:
Support!!!!!!!!!!