system/manager
sysman/oem_temp
2.批改用户的暗码
Connected.
User altered.
ORA-28000: the account is locked
SQL>conn sys/change_on_install as sysdba
SQL> alter user scott account unlock;
确认用户：
4.查看全部用户：
select * from all_users;
5.查看用户或人物系统权限：A8站源码交易平台
select * from user_sys_privs;
select * from user_tab_privs;
3 temporary tablespace temp
User created.
ERROR:
SQL> grant create session to kevin; //授权用户可以联接数据库
SQL> grant resource to kevin;
SQL> grant connect,resource to kevin;
------------------------------ ---------------------------------------- ---
CONNECT CREATE CLUSTER NO
CONNECT CREATE SEQUENCE NO
CONNECT CREATE SYNONYM NO
CONNECT CREATE VIEW NO
GRANTEE PRIVILEGE ADM
RESOURCE CREATE TRIGGER NO
RESOURCE CREATE TYPE NO
RESOURCE CREATE CLUSTER NO
RESOURCE CREATE INDEXTYPE NO
8 rows selected.
CONNECT人物：--是颁布最终用户的典型权利，最基本的
CREATE CLUSTER --建立聚簇
CREATE SEQUENCE --建立序列
CREATE SYNONYM --建立近义词
CREATE CLUSTER --建立聚簇
CREATE SEQUENCE --建立序列
CREATE TRIGGER --建立触发器
CREATE INDEXTYPE --建立索引类型
SQL> grant alter,insert,update on scott.emp to kevin; //授权用户kevin批改,刺进，更新表emp的权限
SQL> grant create session, create table to kevin with admin option;
SQL> grant alter,insert,update on scott.emp to kevin with grant option;
假设撤消Kevin的system privilege，James的system privilege权限还存在
enables the grantee to grant the object privilege to other users or roles
SQL> drop role myrole;
sessions_per_user default
cpu_per_call default
idle_time default
logical_reads_per_call default
private_sga default
password_life_time default
password_reuse_max default
password_grace_time default
