Introduction to Oracle9i: SQL (9)

Restricting and sorting data
##CONTINUE##

• Only one privilege can be assigned to a user at any point of time.
• PASSWORD_REUSE_TIME sets the maximum number of days before the password can be reused.
• PASSWORD_LOCK_TIME sets the number of days after which the password will be unlocked.
• PASSWORD_REUSE_MAX sets the maximum number of password changes before which the password can be reused.
• PASSWORD_LIFE_TIME sets the number of days the password will remain valid.
• Create role, Alter role, set role.
• (Syntax)
  REVOKE {privilege [, privilege….] ALL} ON object
  FROM {user [, user…] role PUBLIC}
  [CASCADE CONSTRAINTS];
  
  REVOKE select, insert ON departments FROM scott;