1.oracle有两个系统用户:System (DBA用户) 和Sys(超级管理员)
system用户主要用来管理数据库的对象,只能以normal的方式登录
sys用来维护数据库,权限比system更大,必须以sysdba或sysoper登录
2
1)create tablespace boot_tablespace
datafile 'D:\oracle_dbfile\springboot_db_tablespace.dbf'
size 50M
autoextend on next 30M;
2)create user boot_user
identified by boot_user
default tablespace boot_tablespace;
3)授权
grant connect,resource to boot_user;
4)修改密码
alter user stu_user identified by orcl
5)删除用户
drop user stu_user cascade
6)删除表空间stu_tablespace同时删除数据
drop tablespace stu_tablespace including contents and datafiles
system用户主要用来管理数据库的对象,只能以normal的方式登录
sys用来维护数据库,权限比system更大,必须以sysdba或sysoper登录
2
1)create tablespace boot_tablespace
datafile 'D:\oracle_dbfile\springboot_db_tablespace.dbf'
size 50M
autoextend on next 30M;
2)create user boot_user
identified by boot_user
default tablespace boot_tablespace;
3)授权
grant connect,resource to boot_user;
4)修改密码
alter user stu_user identified by orcl
5)删除用户
drop user stu_user cascade
6)删除表空间stu_tablespace同时删除数据
drop tablespace stu_tablespace including contents and datafiles