采用sys or system / manager as sysdba; 連接數(shù)據(jù)庫。創(chuàng)建普通用戶konglin: create user konglin identified by pwd_Oracle;刪除用戶, drop user konglin;授予用戶登錄數(shù)據(jù)庫的權限： grant create session to konglin;授予用戶操作表空間的權限：grant unlimited tablespace to konglin;grant create tablespace to konglin;grant alter tablespace to konglin;grant drop tablespace to konglin;grant manage tablespace to konglin;授予用戶操作表的權限：grant create table to konglin; (包含有create index權限, alter table, drop table權限)授予用戶操作視圖的權限:grant create view to konglin; (包含有alter view, drop view權限)授予用戶操作觸發(fā)器的權限：grant create trigger to konglin; (包含有alter trigger, drop trigger權限)授予用戶操作存儲過程的權限：grant create PRocedure to konglin;(包含有alter procedure, drop procedure 和function 以及 package權限)授予用戶操作序列的權限：grant create sequence to konglin; (包含有創(chuàng)建、修改、刪除以及選擇序列)授予用戶回退段權限：grant create rollback segment to konglin;grant alter rollback segment to konglin;grant drop rollback segment to konglin;授予用戶同義詞權限：grant create synonym to konglin;(包含drop synonym權限)grant create public synonym to konglin;grant drop public synonym to konglin;授予用戶關于用戶的權限：grant create user to konglin;grant alter user to konglin;grant become user to konglin;grant drop user to konglin;授予用戶關于角色的權限：grant create role to konglin;授予用戶操作概要文件的權限grant create profile to konglin;grant alter profile to konglin;grant drop profile to konglin;允許從sys用戶所擁有的數(shù)據(jù)字典表中進行選擇grant select any dictionary to konglin;