1、系统权限和对象权限
-
System privileges—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 privilegeCREATE
USER
permits a user to create database users. -
Object privileges—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 theDEPARTMENTS
table are examples of object privileges.