启动oracle的控制台,并弹出Add Database to Tree对话框,并填写:
Hostname:本机IP
SID:ora9i//安装之前配置好的
Port Number:1521
然后在connect database界面上输入:
userName:sysman
password:oem_temp
DROP USER OBS_ZHUJP CASCADE;
CREATE USER OBS_ZHUJP PROFILE DEFAULT IDENTIFIED BY OBS_ZHUJP DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP ACCOUNT UNLOCK;
GRANT DELETE ANY TABLE TO OBS_ZHUJP;
GRANT DROP ANY TABLE TO OBS_ZHUJP;
GRANT INSERT ANY TABLE TO OBS_ZHUJP;
GRANT SELECT ANY TABLE TO OBS_ZHUJP;
GRANT UNLIMITED TABLESPACE TO OBS_ZHUJP;
GRANT UPDATE ANY TABLE TO OBS_ZHUJP;
1.授权查询的权限
grant select on 用户.表名 to 用户名;
2.授权某字段更新权限
grant update(col003) on 用户.表名 to 用户名;
3.收回更新权限
rekove update on 用户.表名 from 用户名;
oracle对用户的操作SQL语句
create user "用户名" identified by "密码";
create user "用户名" identified by "密码" TABLESPACE "USERS" ACCOUNT UNLOCK;
//添加帐号时,用户名不能为小写。否则将造成不能登录的问题。
grant "某角色" to "用户名";
grant 某系统权限 to "用户名";
3.修改密码
alter user "用户名" identified by "密码";
4.删除用户
drop user "用户名"
5.列举所有用户
select * from all_users