过年在家比较无聊(非常时期),开始整理这些年中Oracle教学的一些实验文档,后面争取做到每天一篇文章出来(尽量。。。)。
今天来给大家讲讲Oracle权限的基础知识。 Oracle权限分为系统的权限和对象权限两个部分,这两种权限在日常工作中如何区分?在什么样场景下去使用?相信大家通过查找一下官方资料可以获取到答案:
系统权限:
A system privilege gives a user the ability to perform a particular action, or to perform an action on any schema objects of a particular type. For example, the system privilege CREATE TABLE permits a user to create tables in the schema associated with that user, and the system privilege CREATE USER permits a user to create database users.
对象权限:
An object privilege gives a user the ability to perform a particular action on a specific schema object. Different object privileges are available for different types of schema objects. The privilege to select rows from the EMPLOYEES table or to delete rows from the DEPARTMENTS table are examples of object privileges.
以上为官方文档