Oracle登陆
sys 用户sqlplus / as sysdba
添加用户 create user username identified by password;
修改用户 alert user username identified by password;
添加登陆权限 grant create ssession to username;
用户登陆 sqlplus username/password;
建表权限 grant create table to username;
撤销权限 revoke create table to username;
表空间权限 grant unlimited tablespace to username;
查看当前用户的系统权限 select * from user_sys_privs;
插入数据 要提交 commit;
授予对象查询权限 grant select on tablename to username; 谁拥有谁授权
给用户 表的所有权限 grant all on tablename to username; (all与public的区别)
给某表的所有权限 grant create table to public ;
设置行宽度 set linesize 400;
控制权限到列 grant update(rowname) on tablaname to username;
查看列权限 select * from user_col_privs;
授予权限并能分配权限 grant alert any table to username with admin option;
grant select on tablename to username with grant option;
创建角色 create role rolename;
授予角色权限 grant create session to rolename;
授予角色给用户 grant rolename to username;
删除角色 drop role rolename;