- 1【MySQL Shell】8.10 升级 InnoDB ClusterSet_mysql集群升级 router
- 2无坑！部署langchain-chatchat + glm4-9b-chat，轻松实现知识库智能问答！_langchain-chatchat 0.3.0
- 32024辽宁省数学建模B题【钢铁产品质量优化】思路详解_数据驱动的带钢产品质量在线检测模型是什么意思
- 4Java 集合框架：Java 中的优先级队列 PriorityQueue 的实现_java collector 构建priorityqueue
- 5小学生学python什么教材好-小学生学python（一）
- 6值得收藏！2023 年，你应该知道的所有机器学习算法~
- 7【深度学习中的线性代数理解】中的各种量理解：标量、向量、矩阵、张量
- 8利用python进行接口测试及类型_python支持测试得接口类型
- 9使用 Elasticsearch-DSL Python 客户端简化向量嵌入
- 10Kotlin中room数据库的使用_android kotlin room使用
oracle grant all on to,Oracle-授予所有特权？(Oracle- GRANT ALL PRIVILEGES?)
赞
踩
You can grant all [privileges] on , but you aren't specifying an object; so you are granting system privileges:
Oracle Database provides the ALL PRIVILEGES shortcut for granting all the system privileges listed in Table 18-1, except the SELECT ANY DICTIONARY, ALTER DATABASE LINK, and ALTER PUBLIC DATABASE LINK privileges.
System privileges are not always restricted to a schema. That table includes a lot of ANY privileges, which are specifically not restricted to a schema. If you grant all privileges to a user they will be able to create or alter a table in any schema, for example. That probably isn't what you want.
There is no shortcut to grant only schema-restricted privileges. You'll need to grant CREATE TABLE, CREATE INDEX, etc. explicitly.
It's common practice to create a role to which you grant the necessary privileges, and then you just have to grant that role to your users. (Although you sometimes still need to grant privileges directly to users, e.g. if they are required in a stored procedure).
