create role connect / grant create session,alter session,create synonym,create view, create database link,create table,create cluster,create sequence to connect
在dos命令行下面sqlplus 行不行
在sqlplus中,执行CREATE ROLE CONNECT;GRANT ALTER SESSION TO CONNECT; GRANT CREATE CLUSTER TO CONNECT; GRANT CREATE DATABASE LINK TO CONNECT; GRANT CREATE SEQUENCE TO CONNECT; GRANT CREATE SESSION TO CONNECT; GRANT CREATE SYNONYM TO CONNECT; GRANT CREATE TABLE TO CONNECT; GRANT CREATE VIEW TO CONNECT;你执行这些语句的用户必须有 CREATE ROLE 权限,最好是DBA
/
grant create session,alter session,create synonym,create view,
create database link,create table,create cluster,create sequence to connect
行不行
GRANT CREATE CLUSTER TO CONNECT;
GRANT CREATE DATABASE LINK TO CONNECT;
GRANT CREATE SEQUENCE TO CONNECT;
GRANT CREATE SESSION TO CONNECT;
GRANT CREATE SYNONYM TO CONNECT;
GRANT CREATE TABLE TO CONNECT;
GRANT CREATE VIEW TO CONNECT;你执行这些语句的用户必须有 CREATE ROLE 权限,最好是DBA