02Oracle数据库对象-1简介讲解.ppt

例3.6 修改用户zhangsan的密码为ora，并设置默认表空间为users表空间，在该表空间中可以使用无限大的磁盘空间。 Oracle数据库对象 ALTER USER zhangsan IDENTIFIED BY ora DEFAULT TABLESPACE users QUOTA UNLIMITED ON users; 禁用用户账户 ALTER USER user_name ACCOUNT LOCK; 启用用户账户。 ALTER USER user_name ACCOUNT UNLOCK; Oracle数据库对象 启用与禁用用户 例3.7 为数据库中内置的用户账号scott解锁，启用该账号。 ALTER USER scott ACCOUNT UNLOCK; CONNECT scott/tiger; DROP USER user_name [CASCADE] 如果该用户方案中已存在方案对象，则需要带有CASCADE子句。 Oracle数据库对象 DROP USER zhangsan; 例3.8 删除用户zhangsan。 2 Thank You! Objectives This lesson introduces the Oracle server architecture by examining the physical, memory, process, and logical structures involved in establishing a database connection, creating a session, and executing SQL commands. Creating Roles Use the CREATE ROLE statement to create roles. CREATE ROLE system privilege is required. When you create a role that is NOT IDENTIFIED or is IDENTIFIED EXTERNALLY or BY Password, Oracle grants the role with ADMIN option. Use the following command to create a role: CREATE ROLE role [NOT IDENTIFIED | IDENTIFIED {BY password | EXTERNALLY | GLOBALLY | USING package}] where: role is the name of the role NOT IDENTIFIED indicates that no verification is required when enabling the role IDENTIFIED indicates that verification is required when enabling the row BY password provides the password that the user must specify when enabling the role USING package creates an application role, which is a role that can be enabled only by applications using an authorized package Creating Roles Use the CREATE ROLE statement to create roles. CREATE ROLE system privilege is required. When you create a role that is NOT IDENTIFIED or is IDENTIFIED EXTERNALLY or BY Password, Oracle grants the role with ADMIN option. Use the following command to create a role: CREATE ROLE role [NOT IDENTIFIED | IDENTIFIED {BY password | EXTERNALLY | GLOBALLY | USING package}] where: role is the name of the role NOT IDENTIFIED indicates that no verification is