1.System PermissionsUnlimited tablespaceIs hidden inDba, resourceA system permission in the role. When the user obtains the role of dba or resource,The unlimited tablespace system permission is also implicitly authorized to the user.
2.System PermissionsUnlimited tablespaceCannot be grantedRole,Can be granted to users.
3.System PermissionsUnlimited tablespaceWill not followResource, dbaGrantedRoleAnd grant it to the user.
1Lab1
SQL>Create user u1 identified by u1;
User created.
SQL>Grant connect, resource to u1;
Grant succeeded.
SQL>Select * from dba_role_privs a where a. grantee = 'u1 ';
GRANTEEGRANTED_ROLEADM DEF
----------------------------------------------
U1RESOURCENOYES
U1CONNECTNOYES
SQL>Select * from dba_sys_privs a where a. grantee = 'u1 ';
GRANTEEPRIVILEGEADM
-------------------------------------------
U1UNLIMITED TABLESPACENO
SQL>Revoke unlimited tablespace from u1;
Revoke succeeded.
SQL>Select * from dba_sys_privs a where a. grantee = 'u1 ';
No rows selected
2Lab2
SQL>Create role r1;
Role created.
SQL>Grant unlimited tablespace to r1;
ORA-01931: Cannot grant unlimited tablespace to a role
Cannot be authorized to a roleR1.
SQL>Grant unlimited tablespace to u1;
Grant succeeded.
Authorized to usersU1.
3Lab3
SQL>Revoke resource from u1;
Revoke succeeded.
SQL> grant resource to r1;
Grant succeeded.
SQL>Grant r1 to u1;
Grant succeeded.
SQL>Select * from dba_role_privs a where a. grantee = 'u1 ';
GRANTEEGRANTED_ROLEADM DEF
----------------------------------------------
U1R1 NOYES
U1CONNECTNOYES
SQL> select * from dba_sys_privs a where a. grantee = 'u1 ';
No rows selected
The system permission does not exist.Unlimit tablespaceSystem Permissions.