Oracle笔记
oracle 传智播客_ORACLE经典视频教程 笔记(2008-09-09 15:32:34) 标签:it 分类:Oracle
1.3个默认用户
sys chang_on_install
system manager
scott tiger
2.启动监听
lsnrctl start
3.启动实例
oradmin -startup -sid orcl
4.创建用户
create user xx identified by xx;
5.授权
grant create session to lisi;
grant create table to lisi;
grant unlinited tablespace to lisi;
6.查询授权视图
select * from user_sys_privs;
7.撤销权限
revoke unlinited tablespace from lisi;
7.授权
//系统权限
grant alter any table to xxx with admin option;
//对象权限