授予用户执行CRUD的角色和特权是什么(在Oracle 12上) [英] What are roles and privileges to give a user in order to perform CRUD(on Oracle 12)

问题描述

我正在使用 TOAD 在 Oracle 12 c 数据库上创建 USER .

I'm creating a USER on Oracle 12 c database, using TOAD.

创建 TABLESPACE 后，我将创建 USER .我对可以分配给用户的许多 ROLES 和 PRIVILEGES 感到困惑.

After creating the TABLESPACE, I'm creating the USER. I'm a little confusing about the many ROLES and PRIVILEGES that can be given to a USER.

为了执行 CRUD 操作并能够编辑"数据库(创建或删除表，删除模式ecc)，必须赋予用户的最低/标准角色和特权是什么?来自TOAD?

What are the minimum/standard roles and privileges a user must be given in order to perform CRUD operation and being able to 'edit' the database (create or delete table, DROP the schema ecc) from TOAD?

谢谢

推荐答案

这取决于您要执行的操作.如果您只想使用自己的数据库模式中的表，那么以下特权通常足以启动:

It depends on what operations are you going to perform. If you want to work only with tables in your own db schema, then the following privileges are usually enough to start:

grant create session to <your_user>;
grant create table to <your_user>;

您具有插入/更新/删除/选择自己拥有的表的默认权限.

You have the default rights to insert/update/delete/select tables which you own.

表空间配额:

alter user <your_user> quota unlimited on <your_tablespace_name>;

最好为用户设置默认表空间.在这种情况下，您可以在create table语句中省略表空间名称.

It's better to set the default tablespace for the user. In this case you can omit the tablespace name in a create table statement.

alter user <your_user> default tablespace <your_tablespace_name>;

这篇关于授予用户执行CRUD的角色和特权是什么(在Oracle 12上)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！