本文主要是自己的心得体会,大家酌情学习即可:
一:创建用户及navicat登录
1、使用sysdba用户登录
sqlplus / as sysdba
2、创建用户:
create user graph2 identified by Graph_123$;
3、授予用户操作相关权限:
grant create session to graph2;
grant unlimited tablespace to graph2;
grant create tablespace to graph2;
grant alter tablespace to graph2;
grant drop tablespace to graph2;
grant manage tablespace to graph2;
grant create table to graph2;
-- 授予用户操作视图的权限
grant create view to graph2;
-- 授予用户操作触发器的权限
grant create trigger to graph2;
-- 授予用户操作存储过程的权限
grant create procedure to graph2;
-- 授予用户操作序列的权限
grant create sequence to graph2;
二:oracle用户删除
1.查看所有用户:
select * from dba_users;
select * from all_users;
select * from user_users;
2、查看graph用户监听数(命令必须大写):
SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='GRAPH';
output>>>:
SID SERIAL#
---------- ----------
137 41813
335 25993
464 58747
500 9153
531 50402
629 9264
631 11237
664 36180
3、干掉所有监听,逗号为分隔符,必须增加(命令必须大写)
ALTER SYSTEM KILL SESSION '137,41813';
4、重新查看用户连接,并确认无连接在使用
SELECT SID,SERIAL# FROM V$SESSION WHERE USERNAME='GRAPH';
5、删除用户
drop user GRAPH cascade;