用戶權(quán)限角色ppt課件-資料下載頁
2025-05-01 13:51本頁面
【正文】 ...]|ALL} ON object FROM {user[, user...]|role|PUBLIC} [CASCADE CONSTRAINTS]。 Quality is not an act! It`s a habit. Revoking Object Privileges (回收權(quán)限例子 ) As user Alice, revoke the SELECT and INSERT privileges given to user Scott on the DEPARTMENTS table. REVOKE select, insert ON departments FROM scott。 Revoke succeeded. Quality is not an act! It`s a habit. Summary(小結(jié) ) Statement Action CREATE USER Creates a user (usually performed by a DBA) GRANT Gives other users privileges to access the your objects CREATE ROLE Creates a collection of privileges (usually performed by a DBA) ALTER USER Changes a user’s password REVOKE Removes privileges on an object from users In this lesson, you should have learned about DCL statements that control access to the database and database objects:
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1