oracle不能用navicat创建用户,登录无效;
创建用户 管理员登录到需要创建的库
create user 用户名 identified by 密码;
赋予权限
grant connect,resource,dba to 用户名;
create user pdgc identified by “xxxx”;
grant connect,resource,dba to pdgc;
alter user pdgc account unlock;
grant create session to pdgc;
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW , DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE, DBA, CONNECT,RESOURCE,CREATE SESSION TO pdgc;