Oracle数据库用户管理源代码.docxVIP

Oracle数据库用户管理源代码 创建用户 sqlplus/nolog conn sys/ldm as sysdba; create user u1 identified by ldm default tablespace users temporary tablespace temp quot 1M on users account lock; 更改用户 create tablespace t1 datafile e:\t1_01.dbf size 2M autoallocate; alter user u1 default tablespace t1 quota 1M on t1 account unlock / 删除用户 drop user u1 cascade; 查询用户 创建用户u2 create user u2 identified by qy default tablespace t1; 可以通过某些视图（如dba_users）来查看数据库中该用户的一些信息 column username format al0 column profile format a10 column status format a10 select username,profile, account_status status, created from