求教各位高手 oracle 新建一个表空间space 怎么授权给一个已有的用户username

发布网友 发布时间：2022-04-08 03:03

我来回答

共3个回答

热心网友 时间：2022-04-08 04:32

--Create User
create user username
identified by "password"
default tablespace tablename1
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges 授予角色权限
grant connect to username;
grant dba to username;
grant exp_full_database to username;
grant imp_full_database to username;
grant javasyspriv to username;
grant resource to username;
-- Grant/Revoke system privileges 授予系统权限
grant create any sequence to username;
grant alter any table to username;
grant alter any trigger to username;
grant alter session to username;
grant alter system to username;
grant alter tablespace to username;
grant alter user to username;
grant analyze any to username;
grant create any procere to username;
grant create any synonym to username;
grant create any table to username;
grant create any trigger to username;
grant create cluster to username;
grant create database link to username;
grant create procere to username;
grant create public synonym to username;
grant create role to username;
grant create sequence to username;
grant create session to username;
grant create synonym to username;
grant create table to username;
grant create view to username;
grant delete any table to username;
grant drop any index to username;
grant drop any synonym to username;
grant drop any table to username;
grant drop any trigger to username;
grant drop public synonym to username;
grant execute any procere to username;
grant insert any table to username;
grant lock any table to username;
grant select any table to username;
grant unlimited tablespace to username;
grant update any table to username;

说明：授权用grant关键字，上面列举了oracle所具有的大部分角色权限，大部分应该都看懂就不注释了，看不懂再做研究吧，希望对你有用

热心网友 时间：2022-04-08 05:50

每个用户都有个默认的表空间，如果你创建了一个用户，你可以设置该用户的默认表空间，通常是没用使用限额的
alter user xxxx default tablespace xxxx quota unlimited

热心网友 时间：2022-04-08 07:25

要让用户使用这个表空间,设置一个限额就可以了,或者也可以设置为不受限.
alter user username quota unlimited on space;