1.查看所有用戶：

select * from dba_users where username='pjptdb';   
select username from dba_users  ;
select * from all_users;   
select * from user_users;

2.采用oracle創(chuàng)建用戶并授予dba權(quán)限

1）創(chuàng)建用戶： create user pjptdb identified by pjptdb;

2）授予dba權(quán)限  grant connect,resource,dba to pjptdb ;

3.sqlplus遠(yuǎn)程連接

sqlplus dbuser/dbpassword@ip/sid

4.只賦予用戶select inset表（而不是表空間）權(quán)限
步驟：

SQL> create user u1 identified by u1;
User created.
SQL> grant create session to u1;
Grant succeeded.
SQL> grant insert, select on table to u1;

5.改變用戶默認(rèn)使用的表空間

alter user username  default tablespace userspace;

6.刪除非空表空間

drop tablespace tablespace_name including contents and datafiles

7.創(chuàng)建表空間并賦予新的用戶

create bigfile tablespace PJPTDBTS
datafile '/home/oracle/oradata/pjptdb/pjptdbts.dbf' size 500M autoextend on;

CREATE USER pjptusr IDENTIFIED BY pjptusr
alter user pjptusr  default tablespace PJPTDBTS;
grant create table to pjptusr;
grant resource,connect to pjptusr