oracle教学课件尚硅谷宋红康12控制用户权限.ppt

Granting Object Privileges Different object privileges are available for different types of schema objects. A user automatically has all object privileges for schema objects contained in the user’s schema. A user can grant any object privilege on any schema object that the user owns to any other user or role. If the grant includes WITH GRANT OPTION, then the grantee can further grant the object privilege to other users; otherwise, the grantee can use the privilege but cannot grant it to other users. In the syntax: object_priv is an object privilege to be granted ALL specifies all object priv