User Tools

Site Tools


管理oracle

This is an old revision of the document!


# 启动与停止Oracle

# Oracle配置

# Oracle备份与还原

# Oracle用户管理

## 新建用户

参考[How to Create a User and Grant Permissions in Oracle](https://chartio.com/resources/tutorials/how-to-create-a-user-and-grant-permissions-in-oracle/)

``` $ sqlplus / as sysdba

SQL> create user <user_name> identified by <password>; –password含有@符号时会报错,如果希望包含@符号,不清楚如何实现

SQL> grant connect, resource, dba to <user_name>; –为用户授予权限 ```

## 删除用户

# Oracle表空间管理

# 常见Oracle管理问题

管理oracle.1514570118.txt.gz · Last modified: 2021/02/10 21:29 (external edit)