1.新建oracle用户
CREATE USER username IDENTIFIED BY password
2.给用户创建session
GRANT CREATE SESSION TO username;
3.给用户赋予权限
赋予创建表的权限
GRANT CREATE TABLE TO username;
赋予dba的权限
GRANT DBA TO username;
1.新建oracle用户
CREATE USER username IDENTIFIED BY password
2.给用户创建session
GRANT CREATE SESSION TO username;
3.给用户赋予权限
赋予创建表的权限
GRANT CREATE TABLE TO username;
赋予dba的权限
GRANT DBA TO username;