1.请问创建删除帐户怎样写?
CREATE USER admin_dba
IDENTIFIED BY super_user
DEFAULT TABLESPACE dba_ts
TEMPORARY TABLESPACE temp_user_1
QUOTA UNLIMITED ON dba_ts
QUOTA 500K ON SYSTEM
PROFILE mega_user;2. 请问假如帐户存在,用何语名判断?
select * from dba_users
CREATE USER admin_dba
IDENTIFIED BY super_user
DEFAULT TABLESPACE dba_ts
TEMPORARY TABLESPACE temp_user_1
QUOTA UNLIMITED ON dba_ts
QUOTA 500K ON SYSTEM
PROFILE mega_user;2. 请问假如帐户存在,用何语名判断?
select * from dba_users
如果有记录被选出来,证明就存在了!:)
SQL> select * from dba_users;select * from dba_usersORA-00942: 表或视图不存在给它赋权限才行