ORACLE添加新用户并配置权限 添加其他用户的表权限

添加用户配置权限

1.查出表空间所在位置

select tablespace_name,file_id,bytes/1024/1024,file_name

　from dba_data_files order by file_id;

2.根据步骤1查出的路径、将路径替换掉并指定用户名

路径：D:\TABLESPACE\

用户名：KSKFQGHCG

--创建表空间

CREATE TABLESPACE KSKFQGHCG

nologging

DATAFILE 'D:\TABLESPACE\KSKFQGHCG.DBF'

SIZE 64M

AUTOEXTEND ON;

commit;

--创建KSKFQGHCG用户

CREATE USER KSKFQGHCG

IDENTIFIED BY KSKFQGHCG

DEFAULT TABLESPACE KSKFQGHCG TEMPORARY TABLESPACE TEMP

ACCOUNT UNLOCK;

commit;

--授于KSKFQGHCG用户相应权限

GRANT CREATE ANY SEQUENCE TO KSKFQGHCG;

GRANT CREATE ANY TABLE TO KSKFQGHCG;

GRANT ENQUEUE ANY QUEUE TO KSKFQGHCG;

GRANT UNLIMITED TABLESPACE TO KSKFQGHCG;

GRANT CONNECT TO KSKFQGHCG;

GRANT DBA TO KSKFQGHCG;

GRANT RECOVERY_CATALOG_OWNER TO KSKFQGHCG;

GRANT RESOURCE TO KSKFQGHCG;

commit;

只给查询条件只保留

GRANT CREATE ANY TABLE TO KSKFQGHCG;

GRANT RESOURCE TO KSKFQGHCG;

添加其他用户的表权限

登陆需要添加表所在的用户执行

grant select any table to KSKFQGHCG;