3个默认用户
sys change_on_install [as sysdba]
system manager
scott tiger
创建用户
create user lisi identified by lisi;
系统权限
grant create session to lisi;
grant create table to lisi;
grant unlimited tablespace to lisi;
revoke create session from lisi;
revoke create table from lisi;
revoke unlimited tablespace frmo lisi;
grant create session to public;
select * from user_sys_privs;
对象权限
grant select on mytable to lisi;
grant all on mytable to lisi;
revoke select on mytable from lisi;
select * from user_col_privs;
权限的传递
grant alter any talbe to lisi with admin option;
grant select on A to lisi with grant option;
角色
create role myroles;
grant create session to myroles;
drop role myroles;
注意:有些系统权限无法直接赋予角色
create table create any table
alter table alter any table
drop table drop any table
表是属于某一个用户的
角色不属于某个
数据库的三种验证机制
操作系统验证
密码文件验证
数据库验证
linux下oracle的启动过程
lsnrctl start
//sqlplus sys/oralce as sysdba
sqlsplus /nolog
conn sys/oracle as sysdba
startup
windows下oracle的启动过程
lanrctl start
oradmin -startup -sid orcl
sys change_on_install [as sysdba]
system manager
scott tiger
创建用户
create user lisi identified by lisi;
系统权限
grant create session to lisi;
grant create table to lisi;
grant unlimited tablespace to lisi;
revoke create session from lisi;
revoke create table from lisi;
revoke unlimited tablespace frmo lisi;
grant create session to public;
select * from user_sys_privs;
对象权限
grant select on mytable to lisi;
grant all on mytable to lisi;
revoke select on mytable from lisi;
select * from user_col_privs;
权限的传递
grant alter any talbe to lisi with admin option;
grant select on A to lisi with grant option;
角色
create role myroles;
grant create session to myroles;
drop role myroles;
注意:有些系统权限无法直接赋予角色
create table create any table
alter table alter any table
drop table drop any table
表是属于某一个用户的
角色不属于某个
数据库的三种验证机制
操作系统验证
密码文件验证
数据库验证
linux下oracle的启动过程
lsnrctl start
//sqlplus sys/oralce as sysdba
sqlsplus /nolog
conn sys/oracle as sysdba
startup
windows下oracle的启动过程
lanrctl start
oradmin -startup -sid orcl