本文主要是自己的心得体会,大家酌情学习即可:
一:创建用户及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;
-- 授予用户