oracle 创建用户

tupuo

于 2010-03-03 20:58:05 发布

阅读量87

点赞数

文章标签： Oracle

本文详细介绍如何在Oracle数据库中创建表空间、用户，并授予相应的系统权限和对象权限，包括创建表空间、用户及设置默认表空间的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

create tablespace jk datafile 'D:\orcl\tablespace\jk.dbf' size 900m;
create user jk identified by jk default tablespace jk;

grant connect,resource to jk;

grant dba to jk;

或者
GRANT
　　CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
　　ALTER ANY TABLE, ALTER ANY PROCEDURE,
　　DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
　　SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
　　TO jk;

alter user sys identified by 密码

---创建表空间

create tablespace lhy logging datafile '/opt/oracle/oradata/lhy.ora' size 100m autoextend on next 200m maxsize unlimited extent Management local segment space management auto;

----创建用户

Create user lhy profile default Identified by lhy default tablespace lhy;

----附权限

Grant connect to lhy with admin option;

Grant dba to lhy with admin option;

Grant create any table to lhy with admin option;